In excel, formula for most frenquent letter or word entered?

A

ashley

I am trying to enter a formula to find the most frequently entered letter or
word, a "mode" but for text. In this particular case I have a column of the
response either commercial or retail which I have abbreviated with a "C" or
"R" and I would like the formula to return to me which one was the most
frequent response.
 
B

Bob I

Where "G2:G8" is the response cells

=IF(COUNTIF(G2:G8,"=R")>COUNTIF(G2:G8,"=C"),"R","C")
 
Top