Prev: Count decimals
Next: How to sort multiple sheets (which have same format) at one time?
From: Mike H on 23 Mar 2010 09:09
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?
>
 | 
Pages: 1
Prev: Count decimals
Next: How to sort multiple sheets (which have same format) at one time?