M
Maxi
X A B C D E F
1 1 2 3 54 60 65
2 2 3 4 55 61 66
3 3 4 5 56 62 67
4 4 5 6 57 63 68
5 5 6 7 58 64 69
6 6 7 8 59 65 70
7 7 8 9 60 66 71
8 8 9 10 61 67 72
9 9 10 11 62 68 73
10 10 11 12 63 69 74
11 11 12 13 64 70 75
12 12 13 14 65 71 76
13 14 15 66 72 77
14 15 16 67 73 78
15 16 17 68 74 79
16 17 18 69 75 80
17 18 19 70 76
18 19 20 71 77
19 21 72 78
20 22 73 79
21 23 74
22 24 75
23 25 76
24 26 77
25 27 78
I have 25 rows and 6 columns in the range A1:F25. Some of
the cells are blank.
Question:
---------
I want to make combinations of 5 numbers.
Criteria:
---------
1. There should be no duplicates in any single combination
of 5 numbers.
2. Every number in a combination of five numbers should be
taken from different columns.
For example:
1 5 8 20 26 is NOT a valid combination because numbers
given in the last three columns are not used.
8 12 21 55 58 is also NOT a valid combination because
numbers given in the last two columns are not used.
We can skip one column but not more than that.
Result:
-------
1. How many combinations can we get keeping the criteria
in mind?
2. Is it possible to automate this and see which are those
combinations?
Maxi
1 1 2 3 54 60 65
2 2 3 4 55 61 66
3 3 4 5 56 62 67
4 4 5 6 57 63 68
5 5 6 7 58 64 69
6 6 7 8 59 65 70
7 7 8 9 60 66 71
8 8 9 10 61 67 72
9 9 10 11 62 68 73
10 10 11 12 63 69 74
11 11 12 13 64 70 75
12 12 13 14 65 71 76
13 14 15 66 72 77
14 15 16 67 73 78
15 16 17 68 74 79
16 17 18 69 75 80
17 18 19 70 76
18 19 20 71 77
19 21 72 78
20 22 73 79
21 23 74
22 24 75
23 25 76
24 26 77
25 27 78
I have 25 rows and 6 columns in the range A1:F25. Some of
the cells are blank.
Question:
---------
I want to make combinations of 5 numbers.
Criteria:
---------
1. There should be no duplicates in any single combination
of 5 numbers.
2. Every number in a combination of five numbers should be
taken from different columns.
For example:
1 5 8 20 26 is NOT a valid combination because numbers
given in the last three columns are not used.
8 12 21 55 58 is also NOT a valid combination because
numbers given in the last two columns are not used.
We can skip one column but not more than that.
Result:
-------
1. How many combinations can we get keeping the criteria
in mind?
2. Is it possible to automate this and see which are those
combinations?
Maxi