Forum Discussion

rlclynn's avatar
rlclynn
Copper Contributor
Apr 26, 2024

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...
excel
Formulas and Functions
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 26, 2024

rlclynn 

Insert a helper column:

=OR(Sales_Split="HIPPKE",Sales_Split_2="HIPPKE")

And filter for TRUE.

 

Resources