Most Common Letter in string

[hawkinsr86]

Hi guys,

I was wondering if you could help. I am try to create a formula which would pull the most common letter from a string.

For example, cell A1 contains MMMWW, I would like the formula to return M

Thanks!

 

[footoo]

https://www.mrexcel.com/forum/excel-questions/490140-find-most-common-letter-string.html