All Possible Number Combinations

K

Kate

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.
 
M

Mike H

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
 
K

Kate

Yes, 0000 would be a valid combination.

Mike H said:
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
 
D

David Biddulph

=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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top