Hi All,

I trying to find a formula that will count the most frequent instances of text in a cell. E.G a single cell contains the text Bob, John, Ken, Bob. The answer here would be Bob

I can do this over a range but not a single cell.

Any ideas?

Thanks