How do I filter or search mulitple for text strings?
 

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!

How do I filter or search mulitple for text strings?
 

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





MikeD wrote:

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

How do I filter or search mulitple for text strings?
 

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.
--
** John C **


"MikeD" wrote:

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!