Forum Discussion
Filter Function - Being able to filter by more than one category within a column
Hello all,
I'm trying to create a search dashboard for a database that I have created. The simplest way I have found to do this is to create drop down menus and then use the filter function: FILTER(array,include,[if_empty]).
It works great, except I think my end users will want to be able to include multiple categories from withing one column, or filter by some of the columns but not by the others. The way that I have organized it now, only forces me to include one category for each section.
=FILTER(Source!A:AA,(Source!E:E='Search Dashboard'!B2)*(Source!F:F=B3)*(Source!G:G='Search Dashboard'!B4),"No Results")
Any thought on how to accomplish this? Or a different way of creating a user-friendly professional looking search dashboard for a database with a lot of information?
Thanks!
4 Replies
CMUNSONMSFUSA , something like this? If not, a sample file will be useful to visualize. Remember to remove all confidential info.
Just in case, another variant for AND
=FILTER(Table2,COUNTIFS(J2:J4,Table2[AAA])*COUNTIFS(K2:K4,Table2[BBB])*COUNTIFS(L2:L4,Table2[CCC]))If not separate from headers
=FILTER(Table2[#All],COUNTIFS(J1:J4,Table2[[#All],[AAA]])*COUNTIFS(K1:K4,Table2[[#All],[BBB]])*COUNTIFS(L1:L4,Table2[[#All],[CCC]]))SergeiBaklan , Nice! Using Countifs as filtering conditions. I learn something new everyday. Thank you!
