Advanced filter I think

[Guest]

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

 

[Guest]

To attract response(s), you should explain your criteria in the posting.

On the face of it, perhaps try Debra's page at:
http://www.contextures.com/xladvfilter02.html

 

[Don Guillett]

copy the header along with your criteria to the criteria range

 

[Peo Sjoblom]

It can be done, it might be more handy using a formula as criteria in the
advanced filter since 10 criteria would take up a lot of space in the
criteria range

Give an example of the criteria, I assume it would be an OR criteria?

 

[Debra Dalgleish]

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 here:

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