Combination Numbers between 000 and 999

[Rashid Khan]

Hello All,
I am using Office XP and searched the NG but could not find a suitable post.
I wish to have a macro which would generate all the possible comibination
between 000 and 999.
eg.
000
001
010
100
...
111
101
110
011
....
I hope I am clear
Can this be achieved.
TIA
Rashid

 

[Tom Ogilvy]

In A1, put in 0
in A2 put in 1
select A1:A2 and do format=>Cells=>Number Tab, select custom and put in 000

now select A1:A2 and drag fill down to row 999

if you want text values: then after doing the above

in B1 put in

=Text(A1,"000")
then drag fill down to row 999
Select column B and do Edit=>Copy, then Edit=>Paste special and select
Values.

then you can delete column A.

 

[Rashid Khan]

Hi Tom
As always u were quick in replying... But pardon me if I have not made
myself clear. I do not wish to have 001, 002... upto 999.. but I want to
have a combination of all the possiblities between 000 and 999
Hope I am clear now
Rashid

 

[E_R]

Uhhh??? Tom's answer DOES give you all combinations between 000 and 999.


Show us what combination of numbers is not there?

Or it that you just don't want them ordered?

 

[Gord Dibben]

Rashid

000 through 999 would be 1000 3-digit numbers.

Possible 3 number combinations would equal 166167000

Possible 3 number permutations would equal 997002000

I would imagine it could be done, but would take some doing.

Myrna Larson has written code. Search google by author and subject
"combinations"

Gord Dibben Excel MVP

 

[Gord Dibben]

Wow, did I miss it or what!! <g>

Gord

Rashid

000 through 999 would be 1000 3-digit numbers.

Possible 3 number combinations would equal 166167000

Possible 3 number permutations would equal 997002000

I would imagine it could be done, but would take some doing.

Myrna Larson has written code. Search google by author and subject
"combinations"

Gord Dibben Excel MVP

 

[Rashid Khan]

Thanks all.
I would have a look at Myrna Larson posting and come back if there is any
problem
Thanks once again to all.
Rashid

Wow, did I miss it or what!! <g>

Gord

 

[Tom Ogilvy]

Myrna's algorithm only uses each digit once in any result set, so it won't
produce any of these:

000
001
010
100
...
111
101
110
011

Just for you edification:
I tricked it by entering each digit 3 times. Then ran permutations and
deleted all the duplicates. The end result was counting from 0 to 999

Perhaps you haven't clearly articulated what you are looking for???

--
Regards,
Tom Ogilvy

Thanks all.
I would have a look at Myrna Larson posting and come back if there is any
problem
Thanks once again to all.
Rashid

 

[George 45]

Rashid

000 through 999 would be 1000 3-digit numbers.

Possible 3 number combinations would equal 166167000

Possible 3 number permutations would equal 997002000

I would imagine it could be done, but would take some doing.

Myrna Larson has written code. Search google by author and subject
"combinations"

Gord Dibben Excel MVP

I'm trying to get the same results
000-999
All single 3 combinations
Eg. 123 would show up as 123,132,213,231,321,312
So 123 gets kept as shown leaving out 132, 200s and 300s mix with the combination 31and 12 between 000-999