Hi Excel geniuses
I need help with generating unique combinations of digit values in column "A":
A ("Input")
0.660
0.742
0.825
0.990
1.155
1.237
1.253
I have attached my workbook. I have used a vba code from a teaching webside, which worked out ok.
The result is marked with light red in my workbook.
However, I have encountered 3 problems:
1. The combinations are stored together in one single cell. Once outputted, I would like them separated in different columns, so I can make a sum total of the combinations. The Blue table is my end goal.
2. The VBA code does not allow each input from the yellow column ("A") to be used more than once. I need each width to be able being used more than once.
3. I would like a constraint inside the VBA code, so only combinations with sum total less than (=<) 3.85 are generated. Is this possible?
I made The Blue table manually to illustrate my end goal. I hope the task makes sense.
1664998082208.png
Bookmarks