Splitting a list of values into 17 separate group of equal sums.

[nicmo]

I have a list of 300+ values. I am trying to group these values into 17 groups where each group has an equal sum of values, or near equal.

E.g. The list is: 1, 3, 4, 2, 2, 1. Two groups would be: 1, 3, 2 (6) and 1, 4, 2 (7).

I have this VBA but it only works for 2 groups.

Please Login or Register  to view this content.

[Leith Ross]

Hello nicmo,

Welcome to the forum!

Because your code references a lot of workbook cells, it is impossible to accurately provide a working solution. Please post a copy of your workbook. You will probably need to post it to a file sharing site because you need 5 or more posts before you can post a workbook here.