Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filtering Multiple Columns | Excel Worksheet Functions | |||
filtering unique in multiple columns | Excel Worksheet Functions | |||
Filtering on multiple columns | Excel Discussion (Misc queries) | |||
Filtering by Columns | Excel Worksheet Functions | |||
Filtering Text Data from Multiple columns | Excel Worksheet Functions |