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?

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

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

random numbers
 

Hello,

You can take my UDF Rando_Pick:
http://sulprobil.com/html/uniqrandint.html

Regards,
Bernd