All Possible Number Combinations
 

I have the following numbers: 0, 1, 2, 3, 4

Looking for a formula that lists all possible four digit combinations for
the above five digits.

i.e.
0001
0002

Thank you.

All Possible Number Combinations
 

Kate,

Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give
an examples of 0001 which uses the zero 3 times. Do you really mean this? If
so is 0000 a valid combination and if not why not? what are the rules?

Mike

"Kate" wrote:

I have the following numbers: 0, 1, 2, 3, 4

Looking for a formula that lists all possible four digit combinations for
the above five digits.

i.e.
0001
0002

Thank you.

All Possible Number Combinations
 

Yes, 0000 would be a valid combination.

"Mike H" wrote:

Kate,

Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give
an examples of 0001 which uses the zero 3 times. Do you really mean this? If
so is 0000 a valid combination and if not why not? what are the rules?

Mike

"Kate" wrote:

I have the following numbers: 0, 1, 2, 3, 4

Looking for a formula that lists all possible four digit combinations for
the above five digits.

i.e.
0001
0002

Thank you.

All Possible Number Combinations
 

Hi,

In which case use the code below to produce the 303600 permutations

http://www.ozgrid.com/forum/showthread.php?t=22673

Mike

"Kate" wrote:

Yes, 0000 would be a valid combination.

"Mike H" wrote:

Kate,

Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you give
an examples of 0001 which uses the zero 3 times. Do you really mean this? If
so is 0000 a valid combination and if not why not? what are the rules?

Mike

"Kate" wrote:

I have the following numbers: 0, 1, 2, 3, 4

Looking for a formula that lists all possible four digit combinations for
the above five digits.

i.e.
0001
0002

Thank you.

All Possible Number Combinations
 

=MOD(INT((ROW(A1)-1)/125),5)&MOD(INT((ROW(A1)-1)/25),5)&MOD(INT((ROW(A1)-1)/5),5)&MOD(ROW(A1)-1,5)
and copy down your 625 rows.
--
David Biddulph

"Kate" wrote in message
...
Yes, 0000 would be a valid combination.

"Mike H" wrote:

Kate,

Yoe need to explain more clearly. You number set is 0,1,2,3,4 and you
give
an examples of 0001 which uses the zero 3 times. Do you really mean this?
If
so is 0000 a valid combination and if not why not? what are the rules?

Mike

"Kate" wrote:

I have the following numbers: 0, 1, 2, 3, 4

Looking for a formula that lists all possible four digit combinations
for
the above five digits.

i.e.
0001
0002

Thank you.