Random Number Generation

  • Thread starter Thread starter Frank Kabel
  • Start date Start date
F

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
Click to expand...
employee's at random to go out on service calls. We are
using this Does anyone know how to do this???
 
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
Click to expand...
...

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

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

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
 
Back
Top