Aug 24 2021 07:43 AM
I am trying to use the =filter function to exclude all names that appear on a list, so if that list expands in the future, I can just add a name and it will filter out the additional names. i also have other criteria I'm using to filter. So in this example, I want to:
1. Exclude all names from the exclusion list
2. Keep only those that are 20 years old
3. Keep only those that are from Des Moines
Is this possible?
Aug 24 2021 08:35 AM
Solution@rapkingb Like this:
=FILTER($AW$8:$AY$52,ISNA(MATCH($AW$8:$AW$52,$AU$8:$AU$15,0))*($AX$8:$AX$52=20)*($AY$8:$AY$52="Des Moine"))
Aug 24 2021 03:01 PM
Aug 24 2021 08:35 AM
Solution@rapkingb Like this:
=FILTER($AW$8:$AY$52,ISNA(MATCH($AW$8:$AW$52,$AU$8:$AU$15,0))*($AX$8:$AX$52=20)*($AY$8:$AY$52="Des Moine"))