Forum Discussion

Peter Rosen's avatar
Peter Rosen
Copper Contributor
Jul 18, 2017
Solved

Filter a list in place

I want to filter the following list in place where any of the 4 quartely columns contain the number 3.   Name     Q1     Q2     Q3     Q4 Peter       1        4        2        1 Lynn        2   ...
filter
  • Detlef_Lewin's avatar
    Detlef_Lewin
    Jul 18, 2017

    Hi

     

    Insert a helper column ...

    =COUNTIF(Table1[@[Q1]:[Q4]],3)>0

    ... and filter on TRUE.

     

Detlef_Lewin's avatar
Detlef_Lewin
Silver Contributor
Jul 18, 2017

Hi

 

Insert a helper column ...

=COUNTIF(Table1[@[Q1]:[Q4]],3)>0

... and filter on TRUE.

 

Peter Rosen's avatar
Peter Rosen
Copper Contributor
Jul 18, 2017

Thanks Detlaf---that worked perfectly.

Resources