default_name
Board Regular
- Joined
- May 16, 2018
- Messages
- 170
- Office Version
- 365
- 2016
- Platform
- Windows
- MacOS
Hello,
I have a table with a list of Keywords.
I also have a list of Item Descriptions.
I am trying to figure out how to count the number of times any of the keywords from the list are mentioned in each item description.
For random example:
<tbody>
</tbody>
I have tried doing a SUMPRODUCT and an ISNUMBER SEARCH but have gotten really turned around.
Thanks in advance for your help!
I have a table with a list of Keywords.
I also have a list of Item Descriptions.
I am trying to figure out how to count the number of times any of the keywords from the list are mentioned in each item description.
For random example:
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | Keywords: | orange | smooth | metal | sleeve | 2319 | webbed | coated | alloy | voltage | taco | accessory | hardened | stain |
2 | ||||||||||||||
3 | Item Description: | Webbed metal bar for orange shelf | Blue titanium welding attachment | Orange stained metal dividing sleeve | Delicious steak taco | Voltage meter #2319 | 0048171 Hardened taco alloy (PFCJ777) | |||||||
4 | Number of times a listed keyword showed up: | 3 | 0 | 4 | 1 | 2 | 3 |
<tbody>
</tbody>
I have tried doing a SUMPRODUCT and an ISNUMBER SEARCH but have gotten really turned around.
Thanks in advance for your help!
Last edited: