samyscraps01
Board Regular
- Joined
- Jul 6, 2017
- Messages
- 58
I have a list of managers (column A), a list of departments that are assigned to these managers (the amount varies) (column B), the final column contains the amount/values of employees in each dept (column C).
The purpose of the list is to distribute it to 6 different people. I need 6 different buckets so that each bucket contains roughly the same amount of employees.
The catch is that I need to group the buckets together so that as many of the same managers remain in the one bucket rather than randomly scattered over all 6 buckets. This makes it easier on the distribution so that each of the 6 employees has the consistency of working with the same manager. Also, I can’t have half of a group of employees in one bucket from the same department and the other half in another bucket.
Sample below
Sam, MGR, Social Services Dept., 12 Employees.
John, MGR, HR Dept., 25 Employees.
Kelly, MGR, Payroll Dept., 48 Employees.
Sam, MGR, Education Dept., 6 Employees.
Any assistance is greatly appreciated!
THANK YOU.
The purpose of the list is to distribute it to 6 different people. I need 6 different buckets so that each bucket contains roughly the same amount of employees.
The catch is that I need to group the buckets together so that as many of the same managers remain in the one bucket rather than randomly scattered over all 6 buckets. This makes it easier on the distribution so that each of the 6 employees has the consistency of working with the same manager. Also, I can’t have half of a group of employees in one bucket from the same department and the other half in another bucket.
Sample below
Sam, MGR, Social Services Dept., 12 Employees.
John, MGR, HR Dept., 25 Employees.
Kelly, MGR, Payroll Dept., 48 Employees.
Sam, MGR, Education Dept., 6 Employees.
Any assistance is greatly appreciated!
THANK YOU.
