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.
|