How do I randomly select a cell without replacement?

[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?

 

[Gary''s Student]

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................

 

[Pete_UK]

Take a look at Debra Dalgleish's site here:

http://www.contextures.com/xlDataVal03.html

showing how to hide previously used items in a drop-down.

Hope this helps.

Pete