Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Use a 4th help column
=OR(E20,G20I20) copy down as long as needed then filter on the help column and TRUE or use advanced filter, assume the headers are columnE, G and I then the OR criteria would look like ColumnE ColumnG ColumnI 0 0 0 so it would take 12 cells for the criteria -- Regards, Peo Sjoblom "Keleigh-G" wrote in message ... I'm attempting to filter columns E, G, and I all at the same time. I need to display rows that have values greater than 0 in any one of those three columns. So far I can only filter progressively. If I filter column E and then filter column G, the second filter is only applied to the results of the first filter. Does anybody know if it's even possible to do what I'm trying to do? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
filter rows rather than columns in Excel 2003? | Excel Discussion (Misc queries) | |||
how do I filter for 1 variable in multiple columns | Excel Worksheet Functions | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
How do i copy columns of data in notepad into microsoft excel? | Excel Discussion (Misc queries) | |||
Filter two columns with criterion applying to one or the other? | Excel Discussion (Misc queries) |