View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
CJ CJ is offline
external usenet poster
 
Posts: 102
Default Automatically shorten a list of names

I have a list of 36 names in column A. When 1 name is randomly selected it is
removed form the the list, written in another cell and the original list
shrinks to 35. When the operation is repeated another name is randomly
removed, written in another cell and the list is again decreased. This
constant decrease could go on until every name is used only once. Any ideas
please.