Can Excel randomly pick one winner out of 100 contest entries?
Thank you.
Have a good day.
"Peo Sjoblom" wrote:
Maybe not exactly what you expected but one way would be to use this
technique, assume the entries are in A1:A500, in an adjacent cell (B1) put
=RAND()
copy down to B500, select both columns and do datasort and sort by column
B. Now just pick the winner in A1.
Regards,
Peo Sjoblom
"Bernard" wrote in message
...
I want to use Excel to randomly select a winner out of a lot of entries.
Is there a program in Excel that can randomly select a row out of XXX
rows?
|