Use criteria in an Advanced Autofilter's single column

  • Thread starter Thread starter Chilidog
  • Start date Start date
C

Chilidog

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.
 
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
 
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
 
Thanks Bernie. Unfortunately with the other column selectors it creates too
many combinations to continually add new criteria to the next row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter problem 7
How can I specify more than 2 criteria in AutoFilter 2
Suppressing Values in Autofilter Criteria List 1
AutoFilter Criteria using named range 4
AutoFilter Issue 2
AutoFilter - Lack or Experience 9
VBA: How can I use a string variable as autofilter criteria? 4
Autofilter multiple criteria using array 3

Back
Top