Find cells that contain repeated words within a string

[ollyhughes1982]

Hi,

Re the below screenshot, would anybody please be able to advise how to find and count cells in a particular column that contain repeated words. In this example, manually counting shows that the result should be 3. Cardiff parkrun, Newport parkrun and Sharpham Fields Road parkrun do not contain repeated words, the other 3 do. The words can be anywhere in the string, they don't have to be consecutive.

I've tried a few things, but nothing is working.

Thanks in advance.

Olly.

 

[Fluff]

Looks like you need to change B2 to B3

 

[ollyhughes1982]

Oh dear, oh dear, that really is a dumb one by me. Apologies!

 

[Fluff]

No worries, we've all been there.