Use criteria in an Advanced Autofilter's single column
 

I have an Adv Autofilter that has 9 different columns as criteria. I want to
use 1 column to do an " Or" statement, e.g Salaried Or Hourly, the other
columns may have "or" statements as well. I cannot figure out how the string
must look for the autofilter to recognize it. Thus when I put in Salaried or
Hourly it returns nothing. Is there a way that can be done? Any help is
very much appreciated.

Use criteria in an Advanced Autofilter's single column
 

In the Column with the criteria, you must add another row: in the first row
beneath the header, enter Salaried, in the second row beneath the header,
enter Hourly.

HTH,
Bernie
MS Excel MVP


"Chilidog" wrote in message
...
I have an Adv Autofilter that has 9 different columns as criteria. I want
to
use 1 column to do an " Or" statement, e.g Salaried Or Hourly, the other
columns may have "or" statements as well. I cannot figure out how the
string
must look for the autofilter to recognize it. Thus when I put in Salaried
or
Hourly it returns nothing. Is there a way that can be done? Any help is
very much appreciated.

Use criteria in an Advanced Autofilter's single column
 

I should have noted that you will need to expand the range selected for the
filter criteria by an additional row, when in the dialog.

Bernie


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
In the Column with the criteria, you must add another row: in the first
row beneath the header, enter Salaried, in the second row beneath the
header, enter Hourly.

HTH,
Bernie
MS Excel MVP


"Chilidog" wrote in message
...
I have an Adv Autofilter that has 9 different columns as criteria. I want
to
use 1 column to do an " Or" statement, e.g Salaried Or Hourly, the other
columns may have "or" statements as well. I cannot figure out how the
string
must look for the autofilter to recognize it. Thus when I put in
Salaried or
Hourly it returns nothing. Is there a way that can be done? Any help is
very much appreciated.

Use criteria in an Advanced Autofilter's single column
 

Thanks Bernie. Unfortunately with the other column selectors it creates too
many combinations to continually add new criteria to the next row.

"Bernie Deitrick" wrote:

I should have noted that you will need to expand the range selected for the
filter criteria by an additional row, when in the dialog.

Bernie


"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
In the Column with the criteria, you must add another row: in the first
row beneath the header, enter Salaried, in the second row beneath the
header, enter Hourly.

HTH,
Bernie
MS Excel MVP


"Chilidog" wrote in message
...
I have an Adv Autofilter that has 9 different columns as criteria. I want
to
use 1 column to do an " Or" statement, e.g Salaried Or Hourly, the other
columns may have "or" statements as well. I cannot figure out how the
string
must look for the autofilter to recognize it. Thus when I put in
Salaried or
Hourly it returns nothing. Is there a way that can be done? Any help is
very much appreciated.