find the maximum number of appearances in a range

[a7n9]

Hello all,

I've rows with some numbers in it. like this

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T
1	S1	S2	S3	S4	S5	S6	S7	S8	S9	S10	S11	S12	S13	S14	S15	S16	S17	S18	S19	S20
2	15	15	7	4	8	18	0	4	13	5	15	7	10	14	14	11	1	15	14	8
3	1	1	0	18	3	0	3	16	9	12	1	0	17	18	8	10	15	4	2	11
4	1	8	15	9	1	6	0	8	10	8	6	8	6	1	4	5	2	18	0	2
5	17	4	5	11	14	0	7	16	11	13	6	17	18	9	8	15	3	16	7	9
Sheet1

I want to find which number has made the maximum number of appearances for each row. For the first row 15 has appeared 4 times.

Thanks for your help.

 

[tactps]

=MODE(1:1)
or
=MODE(A1:U1)

and copy down.

 

[a7n9]

Haha... I forgot it's called as "Mode"..thanks anyway.