|
|
#1
12-15-2020, 06:06 PM
|
|||
|
|||
Find first mention of word from list.
Hello, In this attached database I have a list of words (Column G). I want to find the first mention of any of the column G words in the strings (Column A). That first mention would be in column B as shown. I have some experience with this (=ClearWords(A2,G$2:G$150) but I cannot figure out which function to use or how to relate this with this new situation where I don’t want to clear the word but show the first mention of any of the listed words. Thank you 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How to find (highlight) two and more words in a list of 75k single words in Word 2010 | Usora | Word | 8 | 05-29-2018 03:34 AM |
| VBA find word and create numbered list under it | WarPiglet | Word VBA | 6 | 04-23-2018 05:06 AM |
| Purpose of the 'Mention' field | Micromegas | Outlook | 0 | 04-11-2016 04:28 PM |
| Find and list Blank pages in Word document. | ndandge | Word VBA | 4 | 11-29-2015 09:15 PM |
 Mail merge custom labels with double mention of addresses
|
bng | Mail Merge | 6 | 05-30-2013 03:00 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode