How do I filter or search mulitple for text strings?

[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!

 

[Dave Peterson]

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*") + ....

 

[John C]

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.