"Bob Phillips" wrote...
JE's formula does have one, significant IMO, advantage over that one,
in that it works if there are empty cells in the range, the second
errors out.
....

The other formula could be adapted.

=INDEX(rng,MODE(MATCH(rng&"",rng&"",0)))

That'd take care of blank cells. There's still another problem: if there are
only distinct entries in rng, MODE will return an error.