SOLVED

Using =filter function with excluding criteria from list

Copper Contributor

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_1-1629816113464.png

 

 

2 Replies
best response confirmed by rapkingb (Copper Contributor)
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"))
Excellent. Thank you very much!
1 best response

Accepted Solutions
best response confirmed by rapkingb (Copper Contributor)
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"))

View solution in original post