Try this array formula** :

=INDEX(A2:A24,MODE(MATCH(A2:A24,A2:A24,0)))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

Copy across as needed.

--
Biff
Microsoft Excel MVP


"Darren" wrote in message
...
I have 3 columns of 24 cells headed 'gold' 'silver' and 'bronze'. each of
the
24 cells could have 1 of 5 answers depending on other calculations
elsewhere
on the sheet. What function can I put into cell 25 of each column to count
to
most common name? Or to put it another way, to see who won most golds,
silvers and bronzes out of the 5 people?