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.
DarrenBarefoot.com 
Wow…for only having seen one of the nominated movies/performances at the time I voted, I think I did pretty damn good.
For only having seen one of the Best Picture flicks (seabiscuit) and one other (Pirates), I have to say I did as poorly as expected. It’s not about taste: it’s about random guessing. That’s my story and I’m sticking to it.
In truth, I think it’s mostly about politics and who has the most lobbying clout. That doesn’t help you much, I guess.