Count and show higher incidence of results

[Ulisses_Carso]

Count and show higher incidence of results I have a 31-column interval with 4 different values (1, 2.4, 3 and 4.8).

I'm trying to count how many times each of them appears and only show what appears the most times.
I tried use an IF with several sequential COUNTIF but it was too long and the formula ends up conflicting.

Is there a quick way to do this?

 

[ExceLoki]

does this work for you?
------

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF
1	1	2.4	3	3	1	1	2.4	3	1	1	2.4	3	4.8	1	2.4	3	1	1	2.4	3	3	1	1	2.4	3	1	1	2.4	3	4.8	1	2.4
2	most used:
3	1
balance on hand

Cell Formulas
Range	Formula
A3	A3	=INDEX(A1:AF1,MODE(MATCH(A1:AF1,A1:AF1,0)))