| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
random numbers
I have organized a quiz and decided on rewarding 10 correct entries.
I have made a list of the staff ID and the corresponding name of all the correct entries. Is there a way I can get any ten staff IDs from the list at random? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random numbers
On Sun, 18 Oct 2009 17:21:37 +0300, "afdmello"
wrote: I have organized a quiz and decided on rewarding 10 correct entries. I have made a list of the staff ID and the corresponding name of all the correct entries. Is there a way I can get any ten staff IDs from the list at random? If your names are in column A enter the following formula in cell B1: =RAND() copy the formula down as far as you have names in column A. Finally sort columns A and B. (Use Sort by Column B). Then winners are the 10 top names in column A. Hope this helps / Lars-Åke |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random numbers
Thank you Lars,
Can I execute the suggestions by you by the press of a button or key like a macro. afd "Lars-Åke Aspelin" wrote in message ... On Sun, 18 Oct 2009 17:21:37 +0300, "afdmello" wrote: I have organized a quiz and decided on rewarding 10 correct entries. I have made a list of the staff ID and the corresponding name of all the correct entries. Is there a way I can get any ten staff IDs from the list at random? If your names are in column A enter the following formula in cell B1: =RAND() copy the formula down as far as you have names in column A. Finally sort columns A and B. (Use Sort by Column B). Then winners are the 10 top names in column A. Hope this helps / Lars-Åke |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
random numbers
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random Numbers excluding Previous Numbers | Excel Worksheet Functions | |||
| getting numbers divisible by 4 from random numbers in ascending order | Excel Worksheet Functions | |||
| Can Excel pick random numbers from 1-300 and not repeat numbers? | Excel Discussion (Misc queries) | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Worksheet Functions | |||
| Non-random numbers generated by excel's data analysis random gener | Excel Discussion (Misc queries) | |||
Linear Mode
