Forum Discussion
Filtering an Array based on a list of Criteria
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
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
Thank you for your responses, what I ended up getting to work was the following. (Though probably quite inefficient)
IFERROR(SORT(FILTER('Name Projections'!$A$3:$AI$54,ISNUMBER(MATCH('Name Projections'!$C$3:$C$54,Utilization!$H$74:$H$88,0))+ISNUMBER(MATCH('Name Projections'!$D$3:$D$54,Utilization!$H$74:$H$88,0))+ISNUMBER(MATCH('Name Projections'!$E$3:$E$54,Utilization!$H$74:$H$88,0))+ISNUMBER(MATCH('Name Projections'!$F$3:$F$54,Utilization!$H$74:$H$88,0)),"Make Selections"),B4,1),"Needs Selection and/or Sorting Input")
Where the following columns related to specific names that I could select individually with check boxes on another tab would pull their projects and schedules for comparison.
C Column: PMs
D Column: PEs
E Column: Sups
F Column: Sup 2nd
I cant provide the rest of the sheet as it contains current actual projects and information.
Thank you again!
