that works - nice job!!!
Bam! that does the trick - thank you both for your help!
I've attached a slimmed down master excel spreadsheet so you can see the formula I've used. To me it looks identical to the one that was provided. not...
by the way - when I copy my complete master spreadsheet to the spreadsheet you provided with the correct formula it works great. I just copied it to a...
this works great - I only have one more thing. when I copy the formula to my master spreadsheet I don't get the same results. Oddly enough when I c...
I also noticed that if I just copy and paste the exact words you had in column D (for your example) under features it seems to work. But you will noti...
that seems to work. When I apply that to my full Excel spreadsheet it don't get the same results. I can't send the full sheet as it has too much pe...
Frans - I'd like to search each row in column DA. The words I'm searching for are in CY. Each row in DA will match only one of the CY words. O...