Hi,
If there is no blank, you can use this version too:
A2:A14 supposed your range, enter this in B2 for most common value:
=INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0)))
and this for count:
=COUNTIF(A2:A14,B2)
or combined version:
=INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0)))&" - Count "&COUNTIF(A2:A14,INDEX(A2:A14,MODE(MATCH(A2:A14,A2:A14,0))))
Regards,