How do I filter or search mulitple for text strings?

  • Thread starter Thread starter MikeD
  • Start date Start date
M

MikeD

Test filet/customer filet allows me to filter for two separate text strings.
I would like to expand this to filter for 10 or 20 text strings. Any help
much appreciated!
 
You could learn about advanced filter:
http://contextures.com/xladvfilter01.html
(from Debra Dalgleish's site)

Or you could add a helper column that contains a formula that checks for the
strings you want (return true/false or 0/non-zero??) and then filter on this
helper column.

=countif(a2,"*test*") + countif(a2,"*customer*") + ....
 
Microsoft Help has extensive detail on Advanced Filter. You should read up on
it. It tells you how to filter based on single condition/single column all
the way up to multiple conditions/multiple columns.
 
Back
Top