filtering rows across several columns

[MadProphet]

I have a spreadsheet that looks something like this:

Edit # Edit Descr A B C
0001 Missing Phone 1 2 2
0002 Missing Name 2 3 1
0003 Missing Zip 3 3 1

I want to create a filter that will display all rows that have a value of 3
in the A, B, or C columns.

Any ideas on how to proceed?

 

[Mike H]

Hi,

I assume A, B & C are column headings and not the actual columns A,B & C.

Put this in a helper column and drag down

=COUNTIF(C2:E2,3)>0

It will return TRUE if there is a 3 in any of the columns. Filter for TRUE
on this column
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.