Hi! Can someone help me?
I have a list of strings of letters (column A):
YDHEIHGKCEWEC
RIGJSTARSDSFDH
JDSUNDHXSUNFL
HFYEIDGSKQWK
CBVNZTMOONWRH
DASFRERTYBJHX
JDIFJGFFGDFFPG
LKJHMOONDFJHU
And then a list of words (column B):
SUN
MOON
STAR
The words from the second list are hidden in the strings in the first list (I marked them red). The words can be hidden or more than once in the whole list, or even in the same string.
I need a formula in column C which will go through the whole list of words B, and for each of the words, return: how many times the word is hidden in the whole list, and in which string(s).
Any ideas?
Thanks!!
Bookmarks