Random Number Generation

[Frank Kabel]

Hi
if your employees are listed in A1:A10 try the following
in 1:
=INDEX($A$1:$A$10,RANDBETWEEN(1,10))
and copy down

note: The analysis Toolpak Add-in has to be installed

-----Original Message-----
I am trying to use the number generation to pick out 4

employee's at random to go out on service calls. We are
using this Does anyone know how to do this???

 

[hgrove]

Frank Kabel wrote...

if your employees are listed in A1:A10 try the following in 1:
=INDEX($A$1:$A$10,RANDBETWEEN(1,10))
and copy down

...

C'mon, Frank, you know that RANDBETWEEN can produce duplicates
Something tells me the OP wants 4 *distinct* individuals

 

[Frank Kabel]

Frank Kabel wrote...

..

C'mon, Frank, you know that RANDBETWEEN can produce duplicates.
Something tells me the OP wants 4 *distinct* individuals.

lol
Hi Harlan
thought that myself after hitting the SEND button. But I hoped no one
would catch this

So for the OP: Use one of the other suggested methods

Frank