Filter a list in place

[Peter Rosen]

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        1        3        4

Kevin       3        4        1        1

Paul         4        2        2        4

The answer I should receive is the row with Lynn and the row with Kevin.

Any help you can provide would be greatly appreciated.

[#2 · Accepted solution]

Hi

Insert a helper column ...

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

... and filter on TRUE.

[#3]

Thanks Detlaf---that worked perfectly.