Thread: How do I randomly select a cell without replacement?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CT_Jim CT_Jim is offline
external usenet poster
  
Posts: 1
Default 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?

Reply With QuoteReply With Quote