Excel Gurus, Solve My Oscar Crisis
Here’s my quandary. After a little messing about, I’ve got the Oscar contest entries nearly sorted in an Excel spreadsheet. I could, if I was so inclined, compare the winning results with each entry, but that would be a massive pain in the butt.
Surely this is something that Excel can do for me automagically. However, I don’t know how to ask Excel for this favour. Do any of you Excel geniuses know how to do ‘compare and count’ in Excel?
Here is the Excel spreadsheet for your experimental pleasure. I’ve removed the email addresses to protect the innocent (and those who chose Seabiscuit as Best Picture–you know who you are, both of you).
UPDATE: Don, who is clearly a king among men, did my dirty work for me. Here’s the post-magic spreadsheet, which will become my Excel Rosetta Stone for future operations of this type. Thanks also to Brooks Duncan (another king among men, and a senior business analyst, so he knows about these things) who happily reached the same decision with his stats.
