Automatically shorten a list of names

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

Jacob Skaria

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

Bob I

Arrange the names in random order once and then start at the top and
work your way to the bottom.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

how do I create and extract a random order from list in Excel? 5
MAKE A LIST OF NAMES FROM REPEATED NAMES IN THE SAME WORKSHEET 2
Windows 10 One of my previous builds is experiencing random, multiple BSODs 9
formula to pull names out of list 3
How do I randomly sort a list of names? 3
SUMIF, use List as a Range 2
how do I control the sort order of a filter in a pivot table? 1
Filter a Drop List ? 1

Top