#1
|
|||
|
|||
How to distribute a list of 400 among 27 individuals
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 |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
I am finding difficulty at understanding the solution proposed. I can not do it manually because i have again 1000 contacts to distribute among 50 persons. I thought i could do it automatically.
|
#4
|
|||
|
|||
i attach how i want it to look like
|
#5
|
|||
|
|||
Two possible formulas (PasteSpecial formula results into your column as Values, after that you can delete the column with formulas. Or simply use formula.).
When you have different number of persons, you have to edit the persons list reference range in formula. To avoid formula editing, you have to use dynamic named range for names list range defined and used instead of cell reference, or you define both your tables as Tables, and convert provided formula into Table formula. |
#6
|
|||
|
|||
Thank you for your proposed solutions but again they contain difficult formulas. The formula was given to me but I didn't use it.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
VBA to distribute all columns evenly within tables | NorthSuffolk | Word VBA | 3 | 09-23-2017 05:28 PM |
Project does not distribute work evenly between the days | Campelliann | Project | 1 | 01-09-2017 06:01 PM |
Distribute shapes equally | Losey | Visio | 2 | 11-18-2014 01:29 PM |
How to distribute and retrieve information with Outlook 2003 form | freemang | Outlook | 0 | 01-09-2014 02:09 PM |
Resize and distribute width - 2 pictures | AndyDDUK | PowerPoint | 2 | 10-10-2012 03:38 AM |