Dear all,
could you please provide help on my problem listed below:


I have a list of 400 contacts. I want to distribute those contacts among 20 individuals such that each person receives 20 contacts to deal with. On a column besides the contacts, i want my list of 400 to have a different name of individual each time i have counted 20 contacts. For more clarity, please find problem on attached sheet.
thank you in advance for your help

Attached Files

Book11.xlsx (12.2 KB, 11 views)