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
(E-Mail Removed)
"DP7" <(E-Mail Removed)> wrote in message
news:7F233A6A-822B-4FCC-9215-(E-Mail Removed)...
>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" <(E-Mail Removed)> wrote in message
news:7F233A6A-822B-4FCC-9215-(E-Mail Removed)...
>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 here:

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