| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assign a random selection to a range
I have a three colum spreadsheet that is 2000 rows. Row A contains case
numbers I have to select ten rows at a time and then assign a random supervisor to the case number as follows Sup1 = 5 cases, Sup2 = 3 cases, Sup3 = 2 cases. Is there a macro or code that I can use to apply this to the entire range at one time? The cases must be 1 - 10, 11 - 20, 21 - 30, etc. I cannot randomize the numbers. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| can you assign random numbers to many different lines of row? | Excel Worksheet Functions | |||
| How do I generate non-recurring random numbers to assign groups? | Excel Discussion (Misc queries) | |||
| random selection from a range of cells | Excel Worksheet Functions | |||
| Assign a variable from a Listbox selection. | Excel Programming | |||
| Assign a variable from a Listbox selection. | Excel Programming | |||
Threaded Mode
