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:
Use loops and if-then statements. The VB code should be about 15-20 rows
Post a Comment