Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2018, 05:36 AM
Tesla Tesla is offline How to distribute a list of 400 among 27 individuals Windows 7 32bit How to distribute a list of 400 among 27 individuals Office 2003
Advanced Beginner
How to distribute a list of 400 among 27 individuals
 
Join Date: Sep 2018
Posts: 49
Tesla is on a distinguished road
Default 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
Attached Files
File Type: xlsx Book11.xlsx (12.2 KB, 5 views)
Reply With Quote
  #2  
Old 09-05-2018, 07:06 AM
ArviLaanemets ArviLaanemets is offline How to distribute a list of 400 among 27 individuals Windows 8 How to distribute a list of 400 among 27 individuals 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
  #3  
Old 09-06-2018, 10:33 AM
Tesla Tesla is offline How to distribute a list of 400 among 27 individuals Windows 7 32bit How to distribute a list of 400 among 27 individuals Office 2003
Advanced Beginner
How to distribute a list of 400 among 27 individuals
 
Join Date: Sep 2018
Posts: 49
Tesla is on a distinguished road
Default

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.
Reply With Quote
  #4  
Old 09-06-2018, 10:39 AM
Tesla Tesla is offline How to distribute a list of 400 among 27 individuals Windows 7 32bit How to distribute a list of 400 among 27 individuals Office 2003
Advanced Beginner
How to distribute a list of 400 among 27 individuals
 
Join Date: Sep 2018
Posts: 49
Tesla is on a distinguished road
Default

i attach how i want it to look like
Attached Files
File Type: xlsx Book11.xlsx (12.5 KB, 7 views)
Reply With Quote
  #5  
Old 09-06-2018, 10:35 PM
ArviLaanemets ArviLaanemets is offline How to distribute a list of 400 among 27 individuals Windows 8 How to distribute a list of 400 among 27 individuals 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

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.
Attached Files
File Type: xlsx Contacts2.xlsx (18.3 KB, 8 views)
Reply With Quote
  #6  
Old 02-21-2019, 02:22 AM
Tesla Tesla is offline How to distribute a list of 400 among 27 individuals Windows 7 32bit How to distribute a list of 400 among 27 individuals Office 2003
Advanced Beginner
How to distribute a list of 400 among 27 individuals
 
Join Date: Sep 2018
Posts: 49
Tesla is on a distinguished road
Default

Thank you for your proposed solutions but again they contain difficult formulas. The formula was given to me but I didn't use it.
Reply With Quote
Reply

Thread Tools
Display Modes


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
How to distribute a list of 400 among 27 individuals Project does not distribute work evenly between the days Campelliann Project 1 01-09-2017 06:01 PM
How to distribute a list of 400 among 27 individuals 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

Other Forums: Access Forums

All times are GMT -7. The time now is 10:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2021, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2021 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft