Saturday, February 6, 2010

Find Out All Possible Combinations How Create A Database With The Sums Of All Possible Combinations Of 2 To 8 Elements From 28 Different Numbers?

How create a database with the sums of all possible combinations of 2 to 8 elements from 28 different numbers? - find out all possible combinations

I have 2 columns with 28 different numbers each have a program Excel database with the sum of all possible combinations of 2 to 8 parts of 28 bodies in each column and compare the results obtained in order to create similar results.
For example, in the first column of the $ 3550 50 500 125 18.40 = 4234.40 the same as the total 2,000 2,220 14.4 = 4234.4 in the second column. In other words, I find the same quantity with a different number of elements between two columns.
I suppose you do not know how an Excel program that automatically generates all the money possible combination of 2 or 8-28 amounts in the columns and compare them with each other, creating obtain identical results.
Can anyone help?
Thank you.

1 comment:

snfcrick... said...

Use loops and if-then statements. The VB code should be about 15-20 rows

Post a Comment