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?