Can Excel randomly pick one winner out of 100 contest entries?

G

Guest

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

Peo Sjoblom

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 data>sort and sort by column
B. Now just pick the winner in A1.

Regards,

Peo Sjoblom
 
B

Bernie Deitrick

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
 
G

Guest

Thank you.
Have a good day.

Peo Sjoblom said:
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 data>sort and sort by column
B. Now just pick the winner in A1.

Regards,

Peo Sjoblom
Click to expand...
 
G

Guest

Thanks
Have a good day.

Bernie Deitrick said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save RAND select number 3
Random Sort 3
Random select entries 2
Pick data from an array 6
In excel can you randomly select lines from another tab to post? 1
Select a random sample 2
Need formula help 4
How do I pull a name out of a list - randomly? 6

Top