View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom Peo Sjoblom is offline
external usenet poster
 
Posts: 3,268
Default Advanced filter I think

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