View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Darren Darren is offline
external usenet poster
 
Posts: 137
Default Count most common answer.

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?