| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for multiple strings in a list (w/in 1 cell) w/ Advanced fi
Hi,
I'm using Advanced filter, to search for a different criteria and now I'm stuck with this problem. One of my columns contains a list os secondary languages: Users Name Secondary Languages Joe french, german, italian Fred Japanese, french, arabic Using advanced filter, if my criterion is *french*german , it yields Joe, which is great, but if my criterion is *german*french it yields nothing. Is there anything in excel like `*{german, french}` where it can find the two strings regardless of their order? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Advanced Filter w/ multiple sheet List Range | Excel Worksheet Functions | |||
| How to find number of pairs of strings from list of strings? | Excel Worksheet Functions | |||
| Search for strings | New Users to Excel | |||
| Using advanced filter to search for criteria in a list | Excel Discussion (Misc queries) | |||
| How to make a cell recognize multiple text strings? | Excel Worksheet Functions | |||
Threaded Mode
