I have a matrix (14 rows and 5 columns):
1 | 2 | 3 | 4 | 5;
--|---|----|---|--;
66| 67| 68 |69 |70.
All elements are positive integers.
I need to generate all possible combinations from the elements of this matrix. Each combination must contain 14 elements – one from each row.
Sample combinations (with 14 elements each):
1, 6, ... 61, 66;
1, 7, ... 64, 70.
Excel VBA code to return all these combinations will be appreciated.
How many combinations can be formed?
1 | 2 | 3 | 4 | 5;
--|---|----|---|--;
66| 67| 68 |69 |70.
All elements are positive integers.
I need to generate all possible combinations from the elements of this matrix. Each combination must contain 14 elements – one from each row.
Sample combinations (with 14 elements each):
1, 6, ... 61, 66;
1, 7, ... 64, 70.
Excel VBA code to return all these combinations will be appreciated.
How many combinations can be formed?