| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
searching for a word(s) within a list
I have a list of entries and some have US city names and/or states. I want to
be able to identify those cells that have a match for a US city or state in the data. For example see the data below: Jackie Lexington AL James Jones Australia Floyd NE Jamie Salter If I use the list above and match that against a us city/st list I want only the 1st and 3rd entries returned as these are the only 3 that match the criteria and woud find a match in the US city State list. doe this make sense? Is this clear? Let me know. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Searching, matching then searching another list based on the match | Excel Discussion (Misc queries) | |||
| highlight the word when excel finds text you are searching for | Excel Worksheet Functions | |||
| searching within list | Excel Discussion (Misc queries) | |||
| Is Excel or Word better for holding and searching data | Excel Discussion (Misc queries) | |||
| searching a cell for a contained text word | Charts and Charting in Excel | |||
Threaded Mode
