filtering rows across several columns
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.
"MadProphet" wrote:
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?
|