Finding/counting one list in another
Hey
I was wondering if I can somehow count how often a word in one list is found in anotherone?
Also I have two lists the first one is short, the second one is long, what I want: is to count how often a word from the short list match with words out of the long list.
table1
Word1,Word2,Word3
table2
Word1,Word4
I want to know if a word out of table2 is also in table1.
Thanks for help
If every word is in a single cell then =countif(list2,word from list1)
If multiple words in cells, then =SUMPRODUCT(LEN(list2)-LEN(SUBSTITUTE(list2,word from list 1,"")))/LEN(word from list 1)
list2=the long one
list1=the short one
Click the * to say thanks.
Thanks thats working !
But the problem is my list1 is about 700 words and my list2 about 5000.
Is ther a way that the words from list1 are automatically filled into your command?
Not sure what you mean. Something like this?
=countif(a1, H:H) where a1 is first word and H column is for list 2?
And drag it down
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks