Bernard,

Put a column of formulas next to your entries

=RAND()

and then sort both the entries and the column with the formulas based on the formulas. The top
value in the first column would be your winner. Do the sort multiple times (select a number of
times before hand) if you want....

HTH,
Bernie
MS Excel MVP


"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?