Well, you could do a little summary table below your data where you
list the five names, eg in A26:A30, and then in B26 you can use this
formula:

=COUNTIF(A$1:A$24,$A26)

Then you can copy this into C26:D26, and then copy B26:D26 down to
B30. It will show how many Gold, Silver and Bronze each person
received, assuming Gold is in A1:A24, Silver is in B1:B24, and Bronze
is in C1:C24.

You could then use conditional formatting to highlight the highest in
each category, using MAX.

Hope this helps.

Pete

On Sep 2, 10:49*pm, Darren wrote:
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?