In Excel how can I filter multiple columns SIMULTANEOUSLY?

[Guest]

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?

 

[Guest]

Try using the Data > Filter > AdvancedFilter, instead of the
AutoFilter......it will allow "OR" conditions between columns.

Or, if this is something you have to do frequently, you could write a macro
to do the first column in AutoFilter and copy the results to another Sheet
and then do the second and append those results to the second sheet
etc.........

Vaya con Dios,
Chuck, CABGx3

 

[Peo Sjoblom]

Use a 4th help column

=OR(E2>0,G2>0I2>0)

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

 

[Guest]

Advanced filter using the "OR" option will allow me to filter for more than
one criteria in a single column, but it's still only one column that's being
filtered.

Your macro suggestion may be the way to go. I'm not very good with macros,
especially in Excel, but I'll play with it and see what happens.

 

[Guest]

From "HELP".......

Advanced filter criteria can include multiple conditions applied in a single
column, multiple criteria applied to multiple columns, and conditions created
as the result of a formula.

To find data that meets either a condition in one column or a condition in
another column, enter the criteria in different rows of the criteria range.
For example, the following criteria range displays all rows that contain
either "Produce" in the Type column, "Davolio" in the Salesperson column, or
sales values greater than $1,000.


hth
Vaya con Dios,
Chuck, CABGx3

 

[Guest]

did you ever figure out a solution? I have the same problem.