permutations of six digit number

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Dont need anthing but this, there will be 1 million permutations from
000000 to 999999.
 
thanks! that worked great.

i didn't realize that was a million numbers so i'll have to just use a sample.
 
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:
 
Back
Top