In how can i filter multiple columns simultaneously in Excel
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?
Answer:
use the advance filtering option or type in the M column for example =OR(E1>0;G1>0;I1>0)