When you use formulas for distribution, then sorting your table probably affects the distribution. So the formula is not a best solution.

In added example, you can add only persons having lesser number of contacts assigned than anyone other. I.e. at start you can select between 20 persons. After you assign a contact to one of them, you have to select from 19 person for next contact, etc. When all 20 persons have 1 contact assigned, all 20 are available for next contact again. Etc.

When you want initially distribute contacts as batch, and it is egal which contacts are assigned, then copy the name and PasteSpecial as Value it into Contacts table for e.g. 20 contacts - and so for every person.

Attached Files

Contacts.xlsx (18.2 KB, 16 views)