Combination of values targeting a result.

C

Carlos Matheus

Hi guys.

I have a combination problem to solve and I am facing problems on how to picture the solution code in VBA.

I have a given number (n) of groups of 3 numbers each, and I need to create3 bigger groups containing only one number of each of these n groups.
So, at the end, I will have only 3 groups of n numbers each one.

So the problem is finding the combination that gives me the smallest difference between the sum of the elements of each group.
In other words: sum_elements_big_group_1 ≈ sum_elements_big_group_2≈ sum_elements_big_group_3 ≈ sum_all_elements_divided_by_3

Would you have any idea on how to do so?

Cheers.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Centered text that does not stay centered 0
Need some PWA help 0
How to bulk add section breaks after a particular combination of letters/numbers 0
Setting column width in a table with a macro is not working 0
Drop down list control value in vba 2
VBA word change keys 0
How can the font and size of (all) citation numbers be altered? 1
Possible? Variable X and Y data sources and Auto Charting 0

Top