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?
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?