You could make a list of all the accounts and then sort it into
ascending order. Name this list "accounts"

Say you have only 2 reps.

assign large(accounts,1) large (accounts,3) etc to rep1
assign large(accounts,2) large (accounts,4) etc to rep 1

in other words you are assigning alternate accounts to the 2 reps.

This does not guarantee equality, but you could fine tune manually, eg
if one has 250000 more, look for a pair of accounts to exchange


--
robert111
------------------------------------------------------------------------
robert111's Profile: http://www.excelforum.com/member.php...o&userid=31996
View this thread: http://www.excelforum.com/showthread...hreadid=520060