Make all possible sets

[motilulla]

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

	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

 

[motilulla]

Bump

 

[motilulla]

Bump

 

[motilulla]

Bump