| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
random assignments of workload to set # of people
We have 45 different defined tasks that need to be randomly and evenly
distributed each week to the same 4 people. Can this be done with functions or do we need to program a solution? Ideas? Thank you in advance, Dawn -- Dawn Bjork Buzbee |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
random assignments of workload to set # of people
put the names in an equal number of cells in A1 (11 cells each)
list the tasks in B1 to B45 in C1 put in =rand() then drag fill down to C45. Select B1:C45 and sort with C as the key and select no header. Everytime you need a new distribution, do the sort. sequentially assign an employee to the 45th task. -- Regards, Tom Ogilvy "Dawn Bjork Buzbee" wrote in message ... We have 45 different defined tasks that need to be randomly and evenly distributed each week to the same 4 people. Can this be done with functions or do we need to program a solution? Ideas? Thank you in advance, Dawn -- Dawn Bjork Buzbee |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
random assignments of workload to set # of people
Fabulous Tom! Thanks for the quick reply and solution!
-- Dawn Bjork Buzbee "Tom Ogilvy" wrote: put the names in an equal number of cells in A1 (11 cells each) list the tasks in B1 to B45 in C1 put in =rand() then drag fill down to C45. Select B1:C45 and sort with C as the key and select no header. Everytime you need a new distribution, do the sort. sequentially assign an employee to the 45th task. -- Regards, Tom Ogilvy "Dawn Bjork Buzbee" wrote in message ... We have 45 different defined tasks that need to be randomly and evenly distributed each week to the same 4 people. Can this be done with functions or do we need to program a solution? Ideas? Thank you in advance, Dawn -- Dawn Bjork Buzbee |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Random generation of employee assignments | Excel Worksheet Functions | |||
| Random generation of employee assignments | New Users to Excel | |||
| random assignments of workload to set # of people | Excel Worksheet Functions | |||
| When Excel Just Can't Hadle the Workload | Excel Discussion (Misc queries) | |||
| How do I pull a random sample of people from a list in excel? | Excel Worksheet Functions | |||
Linear Mode
