| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically shorten a list of names
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 .... -- Jacob "CJ" wrote: 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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Automatically shorten a list of names
Arrange the names in random order once and then start at the top and
work your way to the bottom. CJ wrote: 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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shorten Data Validation list | Excel Discussion (Misc queries) | |||
| Shorten list into several columns | Excel Discussion (Misc queries) | |||
| Pick List - Shorten KeyStrokes | Excel Discussion (Misc queries) | |||
| create a random list of names from a list of names in EXCEL | Excel Worksheet Functions | |||
| Macro to shorten a list | Excel Discussion (Misc queries) | |||
Hybrid Mode
