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

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"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

copy the header along with your criteria to the criteria range

--
Don Guillett
SalesAid Software

"DP7" wrote in message
...
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

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?


--
Regards,

Peo Sjoblom



"DP7" wrote in message
...
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

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