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?
Bookmarks