SUM totals for specific groups

Hello everyone

I have those numbers
--------------------------
142
158
94
55
15
37
22
60
33
70
58
28
52
25

I need to divide those numbers into five groups .. and as possible as it can be to have nearest equals for each group
The total of these numbers are 849 >> so each group would be nearly about 170 ..
* Each number will be used just for once ..

How can I form the five groups of these numbers to be as possible as it can be to be equal somewhat ??

Posted here too
http://www.eileenslounge.com/viewtopic.php?f=30&t=33777

Create yourself a solver macro

https://www.ppchero.com/how-to-automate-excel-solver/

Thanks a lot. I have a look but I can't do it ..
I will try again when my mind is a little fresh

That's great Alf. Thank you very much
Can you explain the steps by details that lead to such great result??

I have studied the file well and I could get how the steps go through
Thanks a lot for great help

I tried to do the same with four groups instead of five groups but I got unreasonable and incorrect results ...
Can you attach another attempt with the four groups so as to review the results with mine?

Thank you very much. In fact as for five groups as you explained work well. Now I am trying to do the same but with four groups
Is there a way to determine the best min and max values ..? No matter if the differences are large but to make the groups as possible as it can be to be nearly equal .. I don't expect exact equals at all

Don't know any good way to do that but I would use the average and add a min and max constraint and see if solver will find a solution. If so then I would decrease the gap between min and max util solver can't find a solution.

There is also the possibility of setting the groups equal to each other by using a number of constraint for instance in my uploaded file on could test by adding C17=D17, D17=E17 and so forth.

If the average number is an integer then this could work but if the average is a decimal number and the group numbers are integers then it probably won't.

Depending on the situation you could run a macro that takes the average and based on the average adds a min and a max value and do a loop where the min and max value are changed until solver can't find any solution and this stops the macro.

Alf

Thanks a lot for great help ..
Best Regards