Filtering Multiple Columns...

[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!

 

[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

 

[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)

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

---

 

[Max]

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

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

(Aha, gotcha Bob ! <g>)

 

[Bill Foley]

Thanks, guys. Worked a peach! I'll explore a little more to find a VBA
method to turn it on and off.

THANKS!

--
Bill Foley
Microsoft Office Specialist Master Instructor
www.pttinc.com

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

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

(Aha, gotcha Bob ! <g>)

---

 

[Bob Phillips]

ouch ... that hurt!

Bob

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

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

(Aha, gotcha Bob ! <g>)

---