How To Generate All Possible Combinations Of Items From One List

[edebe]

Hi to everybody,

I do have a problem for which I would like to ask your help. I do have a list with decimal number values and I need to calculate all the possible combinations without repetitions.

As you can see in the attached image, I need to calculate not simply 1-element-based combinations, but I need also to calculate all the combinations for 2,3,4,5,6,7,8,9,10-based element combinations.

I already used the combin function to understand how many combinations I will have. Considering that I have 11 elements, the total of the possible combinations are 2047 (no repetitions):

Considering that I'm a rookie, I would like to ask you how can I make this operation without loosing too much time. Thank you in Advance for your help!

 

[edebe]

Did you try it?
The last column is the sum of the combination

Honestly I didn't try it yet. I'm so bad in VBA and I need time to process things.

 

[Akuini]

Sorry, I meant I've amended the code from Mick in that thread, so now it will give you the sum of the combination.

 

[edebe]

Sorry, I meant I've amended the code from Mick in that thread, so now it will give you the sum of the combination.

Ah I see, thanks for that. Now I'll try to make it work somehow.

 

[Akuini]

Here's an example:

dhee - combination.xlsm
	A	B	C	D	E	F	G
1	71,00		71,00				71,00
2	53,22		53,22				53,22
3	48,00		48,00				48,00
4	25,00		25,00				25,00
5			71,00	53,22			124,22
6			71,00	48,00			119,00
7			71,00	25,00			96,00
8			53,22	48,00			101,22
9			53,22	25,00			78,22
10			48,00	25,00			73,00
11			71,00	53,22	48,00		172,22
12			71,00	53,22	25,00		149,22
13			71,00	48,00	25,00		144,00
14			53,22	48,00	25,00		126,22
15			71,00	53,22	48,00	25,00	197,22
Sheet2