Need help on 4 digit number permutations?

[malsha]

Hi

I need help on generating the permutations/combinations of the following 4 digit numbers and spread down to the different cells.

E.G

A1 B1 C1
1234 1235 1236

In each columns are the values...

I want their combinations to spread down the following rows...

E.G

From A2 to A25
1234,2341,3412,4123,4321,4312...etc
From B2 to B25
1235,2351,3512,5123,5321,5312..etc
and the values go on as follows..

Im only concentrating in numbers with 24 permutations and 12 permutations..
24 permutations are 1234,1235,1236...etc
12 permutations are 1123,1124,1125...etc

I need help with the formula..so when i enter the value in A1, the combinations will automatically be in A2 to A25..

Thank you..

[NickyC]

this is clunky code, and I'm sure one of the forum gurus could do better, but I think it works

Please Login or Register  to view this content.

[Cutter]

Duplicate post: http://www.excelforum.com/excel-new-...mutations.html

[malsha]

NickyC,

The code that u have given have some problems.
I try to run the code,but theres an error..

this is clunky code, and I'm sure one of the forum gurus could do better, but I think it works

Please Login or Register  to view this content.

[NickyC]

Hi
it worked ok when I ran it on your spreadsheet.
it relies on using the numbers in the top row - are these still there?
also, what error message do you get, and at what point in the macro?
if you have made changes to the sheet, upload it and I'll take a look

[malsha]

NickyC,

Thanks a lot..It really work..
Before this,i didnt tried it with my previous spreadsheet..
I tried it on another sheet..but it has error..
Now i tried on my 4D combinations spreadsheet..Everyting is perfect..
Thanks alot for the code and advice..