Forum Discussion
Solved
Using =filter function with excluding criteria from list
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?
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"))
2 Replies
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"))- Excellent. Thank you very much!
