How do I randomly select a cell without replacement?
 

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?

How do I randomly select a cell without replacement?
 

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................
--
Gary''s Student - gsnu200770


"CT_Jim" wrote:

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?

How do I randomly select a cell without replacement?
 

Take a look at Debra Dalgleish's site he

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

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

Hope this helps.

Pete

"CT_Jim" wrote in message
...
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?