Count if a word appears

[rikknikk]

I m trying to work out how to look at a range of text in a column and work out how many times each word appears, I have tried the countif function but it only counts words that are in a cell without any others. I have attached an example of what I am trying to do.

Any help would be apprciated!

[zbor]

Use wild character:

=COUNTIF($A:$A, "*"&D1&"*")

Note: This would calculate (for example) "ini" in Mini as a word. it will also count "Strip" as 1 in string "None, Reeses Shelf Strip, Hershey Shelf Strip, Clip Strips, Mini's Rail Defender, Pieces Rail Defender"

[TMS]

Try this, copied across:

Please Login or Register  to view this content.

[rikknikk]

Great thank you very much this seems to have worked!

[TMS]

Doh. Over-engineered again. But interesting