Showing all combinations of a set of numbers

Thanks Alf! This is perfect for what I want.

You are welcome

Thanks for feedback and rep and a Merry Christmas to you.

Alf

Quick question...
I've added some extra rows and edited the visual basic code to adjust for the extra rows, however, when I re-run the macro cell C31 is not including the extra rows that I added.

Do you know how this can be fixed?

Merry Christmas

Chris

Will have a go at it tomorrow. Today the Swedes are celebrating Christmas and even if I'm a Norwegian I do have to join in in in the celebration. You (UK) do it tomorrow? That's "Boxing Day"?

Alf

Thanks, sorry to bother you. I knew it was like that in Poland but wasn't sure about Sweeden/ Norway.

Enjoy the rest of your day!

Chris

Thanks, sorry to bother you.

No problem Chris. After yesterdays celebration it feels good to exercise the brain a bit today. Looking at your uploaded file I found a small problem in the formula in
cell C31 i.e. "=SUMPRODUCT(B3:B22;D3:D22;E3:E22)" but because of the extended range it should be "=SUMPRODUCT(B3:B28;D3:D28;E3:E28"). The ";" is the Scandinavian delimiter
for excel functions.

The C31 problem you mentioned well in my uploaded file I defined the constraint to cell C31 and constraint value to E31 but in the macro where you find the solver setting
I've set B23 to be equal or less than E25 but in the uploaded file I've defined C25 as the constraint and E25 as the max value but both B23 and C25 contains the same formula
so they are equal but yes it can be puzzling.

Stepping through the macro in your uploaded file I did find another much more serious problem. Macro added 13 repetitive results!!!! at the end.

So I modified the formula in cell D29 from "=SUM(D3:D28)" to "=SUMPRODUCT(D3:D28;E3:E28)" and this fixed the repetitive result as well as changing the "If" command for
the jump (skipper) command to "<=8" as it seemed that the original "<=7" command did not work well.

If I compare the result using 7 or 8 for the jump command there are no difference in results that meets the criteria but using 7 I get an false (not meeting criteria) result pasted to
range B214 and a decimal number in cell in B23, but using 8 I only get a 0 value in cell D26 and these tings worry me as I don't know why.

Will probably do a modified macro during the week that places the results in columns next to the original column of values for easily comparison of the different result.

Alf

I correctly update the cell references in the macro, as well as, the formulae in rows 30, 32 and 33?

Yes that's correct. So now enjoy the Christmas season with your family

And I've uploaded a modified file with two macros one presents the result vertically (as before) and the other macro places the result horizontally. As I was not sure if
all the numbers was used at least once I did a check with the countif function in column BZ and they are.

Alf