| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for non-consecutive combination of words in Excel.
EX: I have a spreadsheet of body anatomy and physiology. I want to find every
cell (or row) in my data that contains the non-consecutive words brain AND emotion, for instance. Excel search will find one or the other, but not both words. It could be done in several steps - ie - Step1 - find all instances of 'brain' and copy them to new worksheet Step2 - find all instances of 'emotion' in the secondary worksheet. I don't have much experience with macros, though I have done a bit in Word. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I search for words in all caps in Excel? | Excel Discussion (Misc queries) | |||
| search of words | Excel Discussion (Misc queries) | |||
| Search for repeat words in Excel database | Excel Discussion (Misc queries) | |||
| Search for specific words | Excel Worksheet Functions | |||
| How can I search for words in all caps in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
