Filtering Multiple Columns...
 

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!

--
Bill

Filtering Multiple Columns...
 

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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill Foley" <pttincatitexasdotnet wrote in message
...
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!

--
Bill

Filtering Multiple Columns...
 

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" wrote in message
...
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
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bill Foley" <pttincatitexasdotnet wrote in message
...
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!

--
Bill

Filtering Multiple Columns...
 

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

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

(Aha, gotcha Bob ! <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote in message
...
I would just use

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

and filter on TRUE <g

--
HTH

Bob

Filtering Multiple Columns...
 

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
"Max" wrote in message
...
=COUNTIF(A2:G2,"N")0

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

(Aha, gotcha Bob ! <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote in message
...
I would just use

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

and filter on TRUE <g

--
HTH

Bob

Filtering Multiple Columns...
 

ouch ... that hurt!

Bob

"Max" wrote in message
...
=COUNTIF(A2:G2,"N")0

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

(Aha, gotcha Bob ! <g)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Bob Phillips" wrote in message
...
I would just use

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

and filter on TRUE <g

--
HTH

Bob