How to count a word occurrence in a cell? or a Range?

[Ratan Bhushan]

Hi Team

I have set of few words, of which, we have to count of their occurrence in the whole data set.

I am unable to apply any logic.

Please help.

Thanks
RatanB

 

[Marc L]

Hi !

As your initial post is unclear, from samples within threads see

VBA - extract unique words from range and count - optimization? …
​

 

[Gireesh]

Hi Ratan,

Please use the formula below...File attached for your reference.

=SUMPRODUCT((LEN($A$2:$A$4)-LEN(SUBSTITUTE(LOWER($A$2:$A$4),LOWER($E3),"")))/LEN($E3))