You can create a list on the worksheet, then use a formula in the
criteria to check each row against that list. There's an example he

http://www.contextures.com/xladvfilter02.html#List

DP7 wrote:
I think this can be done by advanced filter but I can't get it to work! I
want to filter my worksheet by 10 different criteria that are in the same
column. If it can be done with an advanced filter how would I set it up? If
it can't be done using this advanced filter what are the other options I
have?

Thanks in advance



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html