+ Reply to Thread
Results 1 to 4 of 4

Divide a set of numbers into 2 (almost) equal sum groups

  1. #1
    Registered User
    Join Date
    10-30-2017
    Location
    California
    MS-Off Ver
    2010
    Posts
    2

    Divide a set of numbers into 2 (almost) equal sum groups

    I have the below set of numbers:

    105,050,000
    96,250,000
    96,200,000
    91,300,000
    81,400,000
    57,750,000
    52,250,000
    29,150,000

    I want to divide them into 2 groups so that the sum of both groups are as close as possible. The total of numbers in each group does not matter.

    How do you do this using the Microsoft excel solver? How would I scale this for additional numbers / more than 2 groups?

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Divide a set of numbers into 2 (almost) equal sum groups

    see attached file.
    If you want more data (rows) correct changed values range and ranges in limits.
    If you want more groups - add new groups and copy sumif formula down, and change uper limit for changed values.
    Attached Files Attached Files
    Best Regards,

    Kaper

  3. #3
    Registered User
    Join Date
    10-30-2017
    Location
    California
    MS-Off Ver
    2010
    Posts
    2

    Re: Divide a set of numbers into 2 (almost) equal sum groups

    Kaper, this worked perfectly thank you. I am still working through trying to figure out how to manipulate the groups/rows using the solver.

  4. #4
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,606

    Re: Divide a set of numbers into 2 (almost) equal sum groups

    Se attached - changes to add some data and divide into 4 groups (screenshot is before running solver)
    Attached Images Attached Images
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. divide 30 numbers into 3 equal sets
    By Jaf0 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 03-09-2016, 12:06 PM
  2. How to divide a set of numbers into 4 equal sum groups
    By ahchin5 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 04-19-2015, 04:20 PM
  3. How to divide a set of numbers into 2 equal sum groups
    By mdsuhair in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-22-2014, 05:13 PM
  4. How to divide a group of numbers in to 3 groups as equal as possible.
    By herbeey in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 06-27-2013, 08:10 PM
  5. How do I group many numbers into 100 equal groups?
    By drdirt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-15-2013, 11:29 PM
  6. Divide set of number into three equal sum groups
    By aboelsous in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-13-2013, 03:09 AM
  7. Divide List of Numbers Into Two Equal Sums
    By iLookup(HELP!, here) in forum Excel General
    Replies: 7
    Last Post: 10-08-2012, 06:13 PM

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