Log In
Register
Home
Active Member
May 28, 2022
Offline
Hello!
Thanks you for providing these formulas (https://www.myonlinetraininghu.....t-of-words)!! Unfortunately, I can't get them to work 🙁 . I downloaded the example file provided on your site and tried each formula provided with no luck and not sure what I am doing wrong. Could you please take a look at my attached file and let me know what I am doing wrong?
Column J is where I placed the code you provided. Column "X" is where I have the "List". Column D is the column I want to search for the words in the list
Thanks in advance for all your help!!
Moderators
January 31, 2022
Offline
Change the named range "List" to be X2:X10. I.e. do NOT include empty cells and it shall work. Wrap the formula in IFERROR if want to avoid the #NUM! error.
Active Member
May 28, 2022
Offline
Hello Riny,
Thanks for your reply. I tried doing that and it didn't work so not sure what I am missing?? Could you please adjust the spreadsheet and send it back so I can see what you are doing to make it work? BTW, you'll want to look at the sheet labeled "June" for where I placed the code.
Thanks for all your help Riny!!
1 Guest(s)
