Contest Results

Good Afternoon,

(working with excel 2003)

I've been charged with tracking sales contest results and setting up a spreadsheet that will select a winner at random.

Column A:Consultant Names
Column B: Number of entries into the Contest

How can i create a "Virtual Hat" that will select a winner for the contest, taking into account the number of entries each person have. (one winner)

I'm fairly experienced with excel formulas, and recording and running macros.

Just looking for the simple way out!

Thanks!

That's really good stuff!

I'll tear that appart later and learn about it, but unfortunately it doesn't fit my scenario.

I've already built the spreadsheet up to have the persons name in column A. (no unique Records)
and the number of their respective enteries in column B. (i.e. the cumulative column C you create in your previous solution.)

i.e.
Col A Col B
Names Entries
Happy 2
Dopey 0
Doc 11


I've fiddled around with your formulas and they're not working for me, i believe due to the fact that it's not one row per entry.