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!!
Trusted Members
Moderators
Power BI
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)
