Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

that is a million numbers.
do you really need all million at once or just a random selection from them.

one way to generate them is
select all the cells format-gell-number-custom 000000
in Cell A1
enter 0
in A2 enter =A1+1

select A2
copy
select A2:A50000
paste
Select B1
enter=A1+50000
copy
select B1:T50000
paste
Select A1:T50000
copy and paste special values

now what do you want to do with them?

"steed800" wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

Dont need anthing but this, there will be 1 million permutations from
000000 to 999999.

steed800 wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

thanks! that worked great.

i didn't realize that was a million numbers so i'll have to just use a sample.

"bj" wrote:

that is a million numbers.
do you really need all million at once or just a random selection from them.

one way to generate them is
select all the cells format-gell-number-custom 000000
in Cell A1
enter 0
in A2 enter =A1+1

select A2
copy
select A2:A50000
paste
Select B1
enter=A1+50000
copy
select B1:T50000
paste
Select A1:T50000
copy and paste special values

now what do you want to do with them?

"steed800" wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks

one possibility for a sample is randbetween(0,999999)
each time it is calculated a new one will be generated
I would copy it about 10 times cause a calc, copy and paste special values
somewhere else.
you may have duplicate numbers:


"steed800" wrote:

thanks! that worked great.

i didn't realize that was a million numbers so i'll have to just use a sample.

"bj" wrote:

that is a million numbers.
do you really need all million at once or just a random selection from them.

one way to generate them is
select all the cells format-gell-number-custom 000000
in Cell A1
enter 0
in A2 enter =A1+1

select A2
copy
select A2:A50000
paste
Select B1
enter=A1+50000
copy
select B1:T50000
paste
Select A1:T50000
copy and paste special values

now what do you want to do with them?

"steed800" wrote:

Hi,

I'm hoping someone could help me.

I need to generate all of the permutations of a six digit number using 0-9
where every number can be repeated and in any order. Is there any way to do
that in Excel or Access?

Thanks