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
rlclynn's avatar
rlclynn
Copper Contributor
Apr 26, 2024
I have to filter multiple persons at end of month. Is there an easier way to accomplish this?
Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Apr 26, 2024

rlclynn 

Unpivot both columns.

 

  • rlclynn's avatar
    rlclynn
    Copper Contributor
    Apr 26, 2024
    Not sure how to do that. I do not have this in a pivot table.
    • Detlef_Lewin's avatar
      Detlef_Lewin
      Silver Contributor
      Apr 26, 2024

      rlclynn 

      You could do it with Power Query.

       

Resources