Hi,
I have a column (data) with words separated by comas. I would like to count how many times the words appear.
I have seen a similar post in this forum where you define the words and then you get the word count. Here I need to get both the list of the words (Column B) and their occurrence (Column C).
Thanks !
I have a column (data) with words separated by comas. I would like to count how many times the words appear.
I have seen a similar post in this forum where you define the words and then you get the word count. Here I need to get both the list of the words (Column B) and their occurrence (Column C).
Thanks !
Data | Result 1 | Result 2 (Count) |
boy,girl,man,woman | aunt | 3 |
uncle,aunt,father | boy | 2 |
aunt,man,boy | father | 2 |
woman,father,aunt | girl | 1 |
man | 2 | |
uncle | 1 | |
woman | 2 |