Automatically shorten a list of names

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

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.
 
If you are looking for a non-VBA solution..select one cell from the 36 cells
you have and move the cursor towards the selection border. When the cursor
turns to a 4-side pointer; click and drag the cell content ....
 
Arrange the names in random order once and then start at the top and
work your way to the bottom.
 
Back
Top