Barchetta99
New Member
- Joined
- Apr 8, 2020
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hi thanks for looking. I have a list of word that are being searched in a column, e.g. red rose blue car.
what i wanted to do was select the first word found in a list of 41 words.
These words are sorted in a hierarchy my most important word 1 and least important 41.
What i am finding is sometimes more than 1 word is found as the picture shows, word, 14, 15 and not shown also 24 adding to 53, there is no word 53 so errors.
Most words are only found once in the search and should be Ok, but i'd like to know which rows had more than 1 find so i can try a different list.
The outcomes defined range aggregates the words so red and blue would aggregate to colour, rose to flower, car to car etc.
I've around 30k rows to look at so it needs to be automated any thoughts greatfully received or a different approach.
what i wanted to do was select the first word found in a list of 41 words.
These words are sorted in a hierarchy my most important word 1 and least important 41.
What i am finding is sometimes more than 1 word is found as the picture shows, word, 14, 15 and not shown also 24 adding to 53, there is no word 53 so errors.
Most words are only found once in the search and should be Ok, but i'd like to know which rows had more than 1 find so i can try a different list.
The outcomes defined range aggregates the words so red and blue would aggregate to colour, rose to flower, car to car etc.
I've around 30k rows to look at so it needs to be automated any thoughts greatfully received or a different approach.