Results 1 to 5 of 5

DIstribute workload based on values across columns

Threaded View

  1. #1
    Registered User
    Join Date
    09-21-2016
    Location
    Dallas, Texas
    MS-Off Ver
    MS Office 2016 Professional
    Posts
    2

    DIstribute workload based on values across columns

    I'm trying to distribute school print activity across four print servers based on the number of staff at the schools. My spreadsheet has one column with the School Name and one column with the Number of Staff. I want to distribute these values across the four Server columns without dividing any school's staff across multiple servers. The total staff per server should be as close as possible to the overall average of staff (e.g., total staff / 4 servers).

    In my example, I have 26 schools named A-Z and the total staff per server should be as close to 540 as possible. Is this possible to do with an Excel formula? If not, can the be done with VBA?

    Thanks for your expert reply!
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Distribute values across columns that equal subtotals
    By rpjohnson in forum Excel Formulas & Functions
    Replies: 12
    Last Post: 09-23-2019, 11:11 AM
  2. [SOLVED] How to Distribute values based in multiple criteria
    By Jllerenp in forum Excel General
    Replies: 11
    Last Post: 06-28-2016, 08:44 AM
  3. [SOLVED] Excel formula to distribute the workload equally to all individual
    By geh17 in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-09-2016, 09:28 PM
  4. Distribute values across columns that equal subtotals
    By espkay in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 01-06-2016, 02:40 AM
  5. [SOLVED] Distribute values in columns based on match between two other columns
    By hydrgal in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-15-2013, 04:07 AM
  6. Replies: 2
    Last Post: 07-14-2010, 02:14 PM
  7. Distribute values evenly in two columns
    By MIckeyLove in forum Excel General
    Replies: 0
    Last Post: 04-27-2006, 11:30 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1