| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi | Excel Discussion (Misc queries) | |||
| Searching for mulitple strings and assigning identifying number | Excel Worksheet Functions | |||
| Search for strings | New Users to Excel | |||
| Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) | |||
| Filter long Text strings | Excel Worksheet Functions | |||
Linear Mode
