Thread: [Solved] Find first mention of word from list.
View Single Post
 
Old 12-15-2020, 06:06 PM
14spar15 14spar15 is offline Windows 7 64bit Office 2010 64bit
Competent Performer
  
Join Date: Mar 2011
Posts: 100
14spar15 is on a distinguished road
Default 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
Attached Files
File Type: xlsm Book2.xlsm (9.8 KB, 9 views)
Reply With Quote