SUM totals for specific groups

[YasserKhalil]

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

[YasserKhalil]

Any help in this topic please?

[HansV]

Too complicated, sorry.

[HansV]

See if this helps: How to divide a set of numbers into 4 equal sum groups

[YasserKhalil]

Thanks a lot Mr. Hans
I have posted here too
https://www.excelforum.com/excel-progra ... roups.html" onclick="window.open(this.href);return false;