View Single Post
  #3   Report Post  
Harlan Grove
 
Posts: n/a
Default

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)))