View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Can I use more than two conditions in custom autofilter?

Hi Chris

take a look at Advanced Filter instead.
You will find help on this at
http://www.contextures.com/xladvfilter01.html

--
Regards

Roger Govier


"Chris M" <Chris wrote in message
...
Within autofilter/ custom you can use two conditional criteria. Is
there a
way I can set up to filter data by looking at a string for more than 2
(ideally up to 10) smaller text strings possibly contained in the
longer
string?