Harlan,

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.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Harlan Grove" wrote in message
oups.com...
JE McGimpsey wrote...
One way (array-entered: CTRL-SHIFT-ENTER or CMD-RETURN):

=INDEX(rng,MATCH(MAX(COUNTIF(rng,rng)),COUNTIF(rn g,rng),0))
...

Somewhat shorter and more efficient is Leo Heuser's approach,

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