From a list select the name with the most occurences

akoobra · Jul 2, 2009

Hi all

I am trying to get a cell to show the which name occurs the most frequently in a list.

Using Excel 2003 and 2007

koob

Teethless mama · Jul 2, 2009

=INDEX(A2:A15,MODE(INDEX(MATCH(A2:A15,A2:A15,),)))