View Single Post
 
Old 09-05-2018, 07:06 AM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
 
Join Date: May 2017
Posts: 652
ArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of lightArviLaanemets is a glorious beacon of light
Default

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
File Type: xlsx Contacts.xlsx (18.2 KB, 8 views)
Reply With Quote