Generating different combinations?

[Brew]

How do I get excel to all return all 1000 different combinations of 0-9 as a 3 number sets to appear in the A,B, C columns:
for example:
A1=0,B1=0,C1=0
A2=0,B2=0,C2=1
and so on,
0,0,2
0,0,3
0,0,4
0,0,5
0,0,6
0,0,7
0,0,8
0,0,9
0,1,1
0,1, 2

A column is 0-9, B column is 0-9 and C column is 0-9

 

[fairwinds]

Hi,

Try this:

Book1
	A	B	C	D	E
1	0	0	0
2	0	0	1
3	0	0	2
4	0	0	3
5	0	0	4
6	0	0	5
7	0	0	6
8	0	0	7
9	0	0	8
10	0	0	9
Sheet1

 

[SIXTH SENSE]

How do I get excel to all return all 1000 different combinations of 0-9 as a 3 number sets to appear in the A,B, C columns:


A column is 0-9, B column is 0-9 and C column is 0-9

you must be kidding in taking 1000 combinations of 0-9!
there are only 120 combinations for these and 720 Permutations.
try
=COMBIN(10,3)=120
and
=PERMUT(10,3)=720

 

[Brew]

Thanks.
Now how do I get excel to generate only accept the unique number combinations. 1-2-3 is the same as 3-2-1. The one that is generated first is accepted. The other is rejected. Using the 0-9 digits for cells E,F,G. It should be 220 combinations.

 

[fairwinds]

Book1
	A	B	C	D	E	F	G	H	I	J
1	0	0	0		000	1		0	0	0
2	0	0	1		001	1		0	0	1
3	0	0	2		002	1		0	0	2
4	0	0	3		003	1		0	0	3
5	0	0	4		004	1		0	0	4
6	0	0	5		005	1		0	0	5
7	0	0	6		006	1		0	0	6
8	0	0	7		007	1		0	0	7
9	0	0	8		008	1		0	0	8
10	0	0	9		009	1		0	0	9
11	0	1	0		001	0
12	0	1	1		011	1		0	1	1
Sheet1

 

[Brew]

Great thanks fairwinds.
Now how do I take the list in H I J and relist them automatically in L M O cells without blank rows as in row 11.
So that the results are in consecutives rows.

 

[fairwinds]

Backing a bit...

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	0	0	0		000	1	1		0	0	0
2	0	0	1		001	1	2		0	0	1
3	0	0	2		002	1	3		0	0	2
4	0	0	3		003	1	4		0	0	3
5	0	0	4		004	1	5		0	0	4
6	0	0	5		005	1	6		0	0	5
7	0	0	6		006	1	7		0	0	6
8	0	0	7		007	1	8		0	0	7
9	0	0	8		008	1	9		0	0	8
10	0	0	9		009	1	10		0	0	9
11	0	1	0		001	0	0		0	1	1
Sheet3

 

[Brew]

That its. Thanks Fairwinds