Which Data Analysis Tool for Data Balancing

[BonerFett]

Hi

I have data of accounts with owners. The current totals for each owner is wrong, but I have a list of what the totals SHOULD be. How can I use Excel to determine new ownership which would reach the desired totals for each owner?

In order to do this, I want excel to tell me who the owners will be on the RAW data (for A, 12 of the 15 lines will keep A as the owner, but the other 3 will be reassigned to either B or D).

Ex:

Current Load		Desired Load
Accts		Accts
A	15	A	12
B	2	B	12
C	24	C	12
D	8	D	13