Randbetween help

  • Thread starter Thread starter Tom
  • Start date Start date
T

Tom

am using Excel 2003 and I have a formula to randomly select employees for a
mandatory drug screen. I have 15 employees and I use the formula
=randbetween(1,15)"Mary","Bill")
etc. having to type in all 15 names. Is there a way to use a named range
with randbetween that refers to text names. I tried naming the range
employees and using =randbetween(1,15) employees . and it didn't work and
then I tried =randbetween("employees" and that didn't work. I even tried
=randbetween(b7:b22) and that failed also
any suggestions? I appreciate the help
 
Drug tests are a waste of money!

List the employee names in a range of cells, say A1:A15.

Then:

=INDEX(A1:A15,RANDBETWEEN(1,15))
 
Drug tests are a waste of money!

List the employee names in a range of cells, say A1:A15.

Then:

=INDEX(A1:A15,RANDBETWEEN(1,15))
 
Back
Top