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