Dear All,
I am trying to count the number of specific words contained in a specific cell. If my data were static, and the list of keywords was short, there are many solutions such as using multiple instances of the length function as proposed by @shg here.
@njimack has proposed a very easy and helpful solution here, but it serves for listing the words and not counting them.
Suppose I have the following sheet: (column C is what I am trying to achieve)
<tbody>
</tbody>
That is, C2 will tell that B2 contained 3 of the keywords (1X beautiful, 2X happy) and so on.
Any recommendations are highly appreciated.
Thanks a lot
I am trying to count the number of specific words contained in a specific cell. If my data were static, and the list of keywords was short, there are many solutions such as using multiple instances of the length function as proposed by @shg here.
@njimack has proposed a very easy and helpful solution here, but it serves for listing the words and not counting them.
Suppose I have the following sheet: (column C is what I am trying to achieve)
A | B | C | |
1 | Keywords | Comments | Count |
2 | happy | Life is beautiful, you just need to stay happy and calm. staying happy is important. | 3 |
3 | stay | no matter what you do, don't get upset! | 1 |
4 | smile | smile in the morning, smile in the evening, smile always | 3 |
5 | beautiful | hello world, how is everyone doing? I am happy | 2 |
6 | upset | don't be upset, cheer up. | 1 |
7 | hello | smile smile, smile. smile, smile | 5 |
<tbody>
</tbody>
That is, C2 will tell that B2 contained 3 of the keywords (1X beautiful, 2X happy) and so on.
Any recommendations are highly appreciated.
Thanks a lot