How do I randomly select a cell without replacement?

  • Thread starter Thread starter CT_Jim
  • Start date Start date
C

CT_Jim

Imagine that I have names in cells A1:A15. The first time I want a name, I
want to randomly select one of the available names and then "cross it off the
list." The second time, I want to select on of the remaining names. I want
to continue this process until all names have been used.

Is there a method for this?
 
In B1 thru B15 enter:
=RAND()
Then sort both columns A & B by column B. This will "shuffle" the names in
column A. After the shuffle, take A1, then A2, then A3................
 
Back
Top