With help I got here some time ago, I was able to build a table that shows how often a string from a master list occurs in a reference list.
<tbody>
R/C
C
D
E
F
G
H
4
Master
Tally
Reference
# Errors
Type
Formula in D
5
jane
2
jane sally polly
0
D5: =COUNTIF($E:$E,"*" & C5 & "*")
6
Joe
3...