How to distribute list account fairly Varian number of people?

I have a problem here about how I could distributed acct's fairly to each team member(people). The condition is I have as exam 3 team members(A,B, C) and each person has got following numbers account in existing : A - 10 acct's, B - 15 acct's, C - 16 acct's. and I have new 10 account's that should distributed to them but the rule is at the ending total account's that they got is same/almost same, then if do manually new 10 acct's will distribute to A: 7 +(10 existing)=17 acct's, B: 2 +(15 existing)= 17acct's, C: 1 +(16 existing)=17 act's. then we could see that each team member will have 17 acct's. as notes number of team member are fix but not with the next new account will distributed

Re: How to distribute list account fairly Varian number of people?

Generic approach: Determine total number of currently assigned customers

Determine total number of customer service reps or what ever you call them

Determine the average number of clients that should be assigned: (new_clients + current_clients)/number of service reps

Subtract the number of current clients per rep from that (rounded) average to get number of new ones.

You'll need a rule for who gets any fraction client left over.

With out a description of how your current data is structured and what you want the final output to look at that's about all I can say at this time as your data structures can make a big difference in how to get the counts mentioned above and how to distribute the new clients.