Formula help - pivot table did not solve my problem

samyscraps01

Board Regular
Joined
Jul 6, 2017
Messages
56
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.
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

Watch MrExcel Video

Forum statistics

Threads
1,114,082
Messages
5,545,856
Members
410,711
Latest member
Josh324
Top