Results 1 to 2 of 2

Distribute Multiple Items Uniquely as Evenly as Possible X amount of times

Threaded View

  1. #1
    Registered User
    Join Date
    11-10-2010
    Location
    Toronto, Ontario
    MS-Off Ver
    Excel 2003
    Posts
    1

    Distribute Multiple Items Uniquely as Evenly as Possible X amount of times

    Is anyone able to point me in the right direction?

    I'm trying to populate the items highlighted in blue in the attached dynamically based on some type of "as evenly distributed as possible" algorithm, is this even possible? if so how?

    The only parameters that change are the values in Column B. The cells with the blue background should show the 10 products uniquely distributed as evenly as possible amongst the 6 agents.

    Please see attached for desired output i've mocked up.

    Any help is greatly appreaciated. Thank-you in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

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