"Ron Rosenfeld" wrote...
....
=INDEX(rng,MATCH(LARGE(UNIQUEVALUES(COUNTIF(rng,r ng)),
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;"";"";"";"";"";""}.