Put the unique list of winners (no duplicates) in C1 and down

in d1
=countif(B:B,C1)

and drag fill down.

You can use the Rank worksheet function to rank the results.

--
Regards,
Tom Ogilvy

"Mat" wrote in message
...
Can anyone advise me on how to create a score card in Excel? I have a
spread sheet that contains 12 monthly winners of a competition (ie column
A1:A12 contains the 12 months of the year and column B1:B12 contains the
winners of each month). I want to be able to use the information in column B
to show me who is in first, second, and third place based on how many months
they have won the competition. Makes sense? Thanks for any help.
Mat