Forum Discussion
Filtering against numerous categories
I am trying to build out a table where numerous individuals need to be captured, with a variety of categories against their names, that I want to be able to search. I'm struggling to come up with the...
=UNIQUE(FILTER(A3:A8,((E3:E8=I1)*(F3:F8=J1))+(G3:G8=K1)))
With this multiple filter criteria we can return a person who is a specialist in Tech Artifacts in Retail or anybody with Risk knowledge at the same time. With UNIQUE each person is only returned once because Person 1 is specialist in both categories and would be returned twice without UNIQUE.