Filtering Multiple Columns...

B

Bill Foley

Hey Gang,

Excel 2003

I have several columns (E through L) of data that have "Y" and "N" values in
them. What I want to be able to do is filter my data where columns E, F, OR
G include "N". If I autofilter the first column, I have inherently gotten
rid of some of the values from another column. I don't want to drill down.
What I want is all data where E = "N" OR F = "N" OR G = "N". I could use a
VBA example if anyone knows of a method.

TIA!
 
M

Max

Use a helper col
In say, M2:
=IF(OR(E2="N",F2="N",G2="N"),"X","")
Copy down, then autofilter for "X" in col M
 
B

Bob Phillips

I would just use

=COUNTIF(A2:G2,"N")>0

and filter on TRUE <g>

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

Max said:
Use a helper col
In say, M2:
=IF(OR(E2="N",F2="N",G2="N"),"X","")
Copy down, then autofilter for "X" in col M
Click to expand...
 
M

Max

=COUNTIF(A2:G2,"N")>0

Believe Bob meant:
=COUNTIF(E2:G2,"N")>0

(Aha, gotcha Bob ! <g>)
 
Top