In Excel how can I filter multiple columns SIMULTANEOUSLY?
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?
|