permutations of six digit number
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
|