Pick a randum employeeID?

S

sybmathics

Hi,

I have in a column ID's for operators/employees like 120-cam-34 or
673-hou-34 or 523-sou-33.
There are 102 unique identifiers.

Now I want Excel to randomly pick an ID from the existing ID's.

I havetried using CHOOSE, but I don't feel like entering all ID's.

Is there another way?

Any help is greatly appreciated.


greets,


Sybolt
 
D

daddylonglegs

If your ids are in A1:A102 to select one at random use this formula.

=INDEX(A1:A102,INT(RAND()*ROWS(A1:A102))+1)

Every time sheet re-calculates (use F9) a new random selection is made
 
S

sybmathics

Hi,

with the help of you both I managed to do what I wanted.

Thanks again.

This group is unbelievable.


Sybolt
 
D

daddylonglegs

Bob said:
=INDEX(A1:A102,CHOOSE(INT(RAND()*102)+1))
Click to expand...

Bob, am I missing something, is this a typo or did you mean to use
CHOOSE, can't have only one argument, surely?
 
Top