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 ha...
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"))
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!
