Make all possible sets
Hello,
I am looking to get all-possible sets of the 14 numbers are listed in the A1:A14
Example attached
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Here is explanation in details. Have post1
1st set of combinations use 1 number only
2nd set of combinationuses first 2 numbers
3rd set of combinationuses first 3 numbers
4th set of combination uses first 4 numbers.... and like this the last 14th set uses all 14 numbers
Thank you all
Excel 2000
Regards,
Moti
Hello,
I am looking to get all-possible sets of the 14 numbers are listed in the A1:A14
Example attached
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | 2 | n1 | n2 | n3 | n4 | n5 | n6 | n7 | n8 | n9 | n10 | n11 | n12 | n13 | n14 | |
2 | 2 | 2 | ||||||||||||||
3 | 2 | 2 | ||||||||||||||
4 | 3 | 2 | ||||||||||||||
5 | 3 | 3 | ||||||||||||||
6 | 3 | 3 | ||||||||||||||
7 | 3 | 3 | ||||||||||||||
8 | 3 | 3 | ||||||||||||||
9 | 4 | 3 | ||||||||||||||
10 | 4 | 4 | ||||||||||||||
11 | 5 | 4 | ||||||||||||||
12 | 5 | 5 | ||||||||||||||
13 | 6 | 5 | ||||||||||||||
14 | 7 | 6 | ||||||||||||||
15 | 7 | |||||||||||||||
16 | 2 | 2 | ||||||||||||||
17 | 2 | 2 | ||||||||||||||
18 | 2 | 3 | ||||||||||||||
78 | 2 | 2 | 2 | 3 | ||||||||||||
79 | 2 | 2 | 2 | 3 | ||||||||||||
80 | 2 | 2 | 2 | 4 | ||||||||||||
151 | 2 | 2 | 2 | 3 | 3 | |||||||||||
152 | 2 | 2 | 2 | 3 | 3 | |||||||||||
153 | 2 | 2 | 2 | 3 | 4 | |||||||||||
254 | 2 | 2 | 2 | 3 | 3 | 3 | ||||||||||
255 | 2 | 2 | 2 | 3 | 3 | 3 | ||||||||||
256 | 2 | 2 | 2 | 3 | 3 | 4 | ||||||||||
379 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | |||||||||
380 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | |||||||||
381 | 2 | 2 | 2 | 3 | 3 | 3 | 4 | |||||||||
512 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | ||||||||
513 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | ||||||||
635 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 7 | ||||||||
636 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | |||||||
637 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | |||||||
638 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 5 | |||||||
739 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | ||||||
740 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 5 | ||||||
741 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 6 | ||||||
811 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | |||||
812 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | |||||
813 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 6 | |||||
854 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | ||||
855 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 6 | ||||
856 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 7 | ||||
873 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | |||
874 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | 7 | |||
875 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 6 | 7 | |||
876 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 5 | 5 | 6 | 7 | |||
877 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 7 | |||
878 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 7 | |||
879 | 2 | 2 | 2 | 3 | 3 | 3 | 3 | 3 | 4 | 4 | 5 | 5 | 6 | 7 |
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
</tbody>
Sheet1
Here is explanation in details. Have post1
1st set of combinations use 1 number only
2nd set of combinationuses first 2 numbers
3rd set of combinationuses first 3 numbers
4th set of combination uses first 4 numbers.... and like this the last 14th set uses all 14 numbers
Thank you all
Excel 2000
Regards,
Moti
Last edited by a moderator: