Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel randomly pick one winner out of 100 contest entries?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel randomly pick one winner out of 100 contest entries?
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel randomly pick one winner out of 100 contest entries?
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Can Excel randomly pick one winner out of 100 contest entries?
Thanks
Have a good day. "Bernie Deitrick" wrote: 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Table to pick out most common entries and count occurences of each | Excel Worksheet Functions | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Is there a way to randomly select rows in Excel? | Excel Discussion (Misc queries) | |||
Contest tracking, Need to show results, daily, weekly and monthy . | Excel Discussion (Misc queries) | |||
How can I total the top 9 scores of 12 weeks in a sporting contest | Excel Discussion (Misc queries) |