On Tue, 31 Jan 2006 08:17:36 -0800, "Harlan Grove" wrote:

"Ron Rosenfeld" wrote...
...
=INDEX(rng,MATCH(LARGE(UNIQUEVALUES(COUNTIF(rng, rng)),
H2),COUNTIF(rng,rng),0))
...

What about multiple modes? If A1:A6 contained {1;2;1;3;2;3}, MODE(A1:A6)
would return 1, the first mode, but 2 and 3 would also be modes. Your
UNIQUEVALUES call would return {2;"";"";"";"";"";""}.



Good point. It would skip some numbers.


--ron