Forum Discussion
Filter 2 columns at the same time in a table
Hi. Newbie here! I have been trying to figure out how to filter two columns at the same time. In this instance, I want to filter the "SPLIT SALES" and "SPLIT SALES 2" columns by "HIPPKE". Essentially...
rlclynn As a variant, the COUNTIF function can be used in a helper column to filter by either a single SalesRep or multiple SalesReps. For example:
=COUNTIF(tblData[@[SALES SPLIT]:[SALES SPLIT 2]], $K$1)>0
...where cell K1 contains a data validation picklist to select the desired SalesRep.
=SUMPRODUCT(COUNTIF(tblData[@[SALES SPLIT]:[SALES SPLIT 2]], tblCriteria[SalesRep]))>0
...where tblCriteria[SalesRep] is a list of names to be included in the filter.
Please see the attached workbook, which also contains two MS365-only examples, using LET, FILTER and a few other dynamic array functions.