Forum Discussion
rlclynn
Apr 26, 2024Copper Contributor
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...
HansVogelaar
MVP
You might add a column with formula =OR([@[SALES SPLIT]]="HIPPKE", [@[SALES SPLIT 2]]="HIPPKE") and filter that column on TRUE.
Alternatively, use Advanced Filter
Detlef_Lewin
Apr 26, 2024Silver Contributor
Great idea, Hans.