Number Combination Checker

[TorFey]

Good day all;

Is it possible to get all the combinations of a set of numbers, for example I have a group of numbers: 1,2,4,8,16,32, how would I go about finding all the possible combinations for this data set? I have made a best guess seen below (20 combinations), but this doesn't seem right to me now:

1 2 4
1 2 8
1 4 8
2 4 8
1 2 16
1 4 16
2 4 16
1 8 16
2 8 16
4 8 16
1 2 32
1 4 32
2 4 32
1 8 32
2 8 32
4 8 32
1 16 32
2 16 32
4 16 32
8 16 32

Thanks for your help in advance
Kind Regards
Tor Fey

 

[cmowla]

This is a recent thread about combinations, where you would type in the numbers that you want combinations of in Cells A2 through H2, for example, and then run that VBA code to give you the full list of combinations in the sheet to the right. There is an even more recent thread where an actual Excel formula is used in the spreadsheet, but that requires newer versions of office. (2021 or 365). So as far as I know, that VBA code is your only option (should you want to do this from Excel).

 

[TorFey]

This is a recent thread about combinations, where you would type in the numbers that you want combinations of in Cells A2 through H2, for example, and then run that VBA code to give you the full list of combinations in the sheet to the right. There is an even more recent thread where an actual Excel formula is used in the spreadsheet, but that requires newer versions of office. (2021 or 365). So as far as I know, that VBA code is your only option.

Thank you very cmowla, i will look at this post now

 

[cmowla]

You can also use Wolfram|Alpha (an online free-version . . . with limited capability of Wolfram's desktop application, Mathematica) to find combinations of objects, should the VBA be too much trouble. (That's an excellent resource for "symbolic" computations . . . Microsoft Office is slowly starting to incorporate Mathematica support into Microsoft Office products.)

 

[TorFey]

You can also use Wolfram|Alpha (an online free-version . . . with limited capability of Wolfram's desktop application, Mathematica) to find combinations of objects, should the VBA be too much trouble. (That's an excellent resource for "symbolic" computations . . . Microsoft Office is slowly starting to incorporate Mathematica support into Microsoft Office products.)

Thanks so much cmowla, the VBA worked a treat