View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chilidog Chilidog is offline
external usenet poster
 
Posts: 6
Default 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.