Forum Discussion

DanielOrtiz's avatar
DanielOrtiz
Copper Contributor
Dec 29, 2019
Solved

I want to filter 2, 3 or more rows depending on the value of one of them...

Hi everyone, 

 

This is probably a very basic question: 

 

I want to be able to filter "groups" of rows based on the value of one of the columns

 

For example:

 

NameStudioUnique CodeFavorite DrinkAddressPhone number
Donald DuckDisney123Coke23 Disney Street 210202020
GoofyDisney124Fanta346 Disney Place1291892
TimonDisney125Sprite234 The Lion king Road12893494
PumbaDisney126Coke12 The Lion King Road129049
WoodyPixar127Sprite33 Toy Story Avenue2309834
RoadRunnerWarner Bross128Coke245 Acme Rd908354
CoyoteWarner Bross129Fanta199 Acme Rd40981340
Bugs BunnyWarner Bross130Sprite345 WB Street134097834
MinionPixar131Fanta24 DespicableMe Road30984
Gru Pixar132Sprite156 DespicableMe Road978350

 

I would like to be able to filter by groups, by studio, for example, if at least one of them likes Coke. 

 

In this case, for the filtered table to look like this: All the characters from Disney studio because at least one of them like coke, and then all the characters of Warner Brothers because at least one of them likes Coke. 

NameStudioUnique CodeFavorite DrinkAddressPhone number
Donald DuckDisney123Coke23 Disney Street 210202020
GoofyDisney124Fanta346 Disney Place1291892
TimonDisney125Sprite234 The Lion king Road12893494
PumbaDisney125Coke12 The Lion King Road129049
RoadRunnerWarner Bross127Coke245 Acme Road908354
CoyoteWarner Bross128Fanta199 Acme road40981340
Bugs BunnyWarner Bross129Sprite345 WB Street134097834

 

The Pixar's characters are gone because no one likes Coke. 

 

How do you do that?

 

Dan

 

 

 

excel
Formulas and Functions

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Dec 30, 2019

    DanielOrtiz 

    You may add helper column like

    =COUNTIFS([Favorite Drink],"Coke",[Studio],[@Studio])>0

    and filter on it.

Resources