Search and Count Key Instances

default_name

Board Regular
Joined
May 16, 2018
Messages
82
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:

A
B
C
D
E
F
G
H
I
J
K
L
M
N
1
Keywords:
orangesmoothmetalsleeve2319webbedcoatedalloyvoltagetacoaccessoryhardenedstain
2
3
Item Description:
Webbed metal bar for orange shelfBlue titanium welding attachmentOrange stained metal dividing sleeveDelicious steak tacoVoltage meter #23190048171 Hardened taco alloy (PFCJ777)
4
Number of times a listed keyword showed up:304123

<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:

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
How about
=SUMPRODUCT(--ISNUMBER(SEARCH($B$1:$N$1,B3)))
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
32,440
Office Version
365
Platform
Windows
You're welcome & thanks for the feedback
 

Forum statistics

Threads
1,082,601
Messages
5,366,571
Members
400,902
Latest member
fathima

Some videos you may like

This Week's Hot Topics

Top