View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bernie Deitrick Bernie Deitrick is offline
external usenet poster
 
Posts: 5,441
Default 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.