Filtering an Array based on a list of Criteria

I have an array that tracks every project that every project manager, project engineer, and superintendent is on and I am trying to set up a function to search through a single list of names and retu...

excel

Formulas and Functions

m_tarler
Apr 03, 2026
You just need to ADD the conditions together:

=FILTER([projectNames], ([name]=[PM])+([name]=[PE]) + ([name]=[SUP]) )

I notice you said you used ISNUMBER(MATCH)) but not sure why or how you have that setup. I could see ISNUMBER(SEARCH(name, PM)) if that field could contain multiple names (e.g. a list of names) and the name you are searching for may be only 1 in the field.

hope that helps you figure it out but if not maybe more info and a copy of the sheet would hel

Forum Discussion

Filtering an Array based on a list of Criteria