Most Frequent Letter in a Column of Four Different Letters

[valmir]

Hello everyone:
I'm using this formula:
=IF(COUNTIF(G3:G14,"b")>MAX(COUNTIF(G3:G14,"c"),COUNTIF(G3:G14,"q")),"b",IF(COUNTIF(G3:G14,"c")>COUNTIF(G3:G14,"q"),"c","q"))
that I found on this post Here
However this formula works perfectly but only for three letters, not four as I need.
Can anyone help me?

 

[valmir]

IFNA works only for Excel 2013 or later. How about:

=IFERROR(INDEX(G3:G14,MODE(IF(G3:G14<>"",MATCH(G3:G14,G3:G14,0)))),"")

I'm using Excel 2010 and this one:
=IF(COUNTIF(G3:G14,"b")>MAX(COUNTIF(G3:G14,"c"),COUNTIF(G3:G14,"q"),COUNTIF(G3:G14,"a")),"b",IF(COUNTIF(G3:G14,"c")>MAX(COUNTIF(G3:G14,"q"),COUNTIF(G3:G14,"a")),"c",IF(COUNTIF(G3:G14,"q")>COUNTIF(G3:G14,"a"), "q",IF(COUNTIF(G3:G14,"a")>0,"a",""))
is working perfectly, so I'll stick to this one. Thanks once again!

 

[kanadaaa]

I'm using Excel 2010 and this one:
=IF(COUNTIF(G3:G14,"b")>MAX(COUNTIF(G3:G14,"c"),COUNTIF(G3:G14,"q"),COUNTIF(G3:G14,"a")),"b",IF(COUNTIF(G3:G14,"c")>MAX(COUNTIF(G3:G14,"q"),COUNTIF(G3:G14,"a")),"c",IF(COUNTIF(G3:G14,"q")>COUNTIF(G3:G14,"a"), "q",IF(COUNTIF(G3:G14,"a")>0,"a",""))
is working perfectly, so I'll stick to this one. Thanks once again!

Ok. But if you ever find it dull to type the loooong formula, try Fluff's.
It automatically picks up the value that appears most frequently in a certain range, so you don't need to type all those abc things.