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