Permutations.

[serge]

Hi,
I'm looking for a formula that will create all permutations possible on 4 rows with the 9 digits in A2:A10, starting in columns C2:C5 to the right, I believe it should be a total of 256 combinations. Thank you.

 

[serge]

Actualy my table example is wrong it should be more like this one.

I kind of get lost with those digits that's why a formula would be so helpful.

 

[Joe4]

, I believe it should be a total of 256 combinations.

Not even close! There will be 6561 different combinations (9*9*9*9).

 

[serge]

You're right forget it then, thank you Joe4.

 

[Joe4]

There may be a way to do it using formulas, but it might use some of the newer functions (if you are really still using Office 2007, you may not have the needed functions available).
In any event, those formulas are beyond me!

If I had to do something like this, I would probably use VBA and use nested loops.
Not the most efficient, but should get the job done!

 

[serge]

Thank you Joe4, but its way to many for what I'm doing, thank you.

 

[Joe4]

OK, you are welcome.

 

[fjns]

Hi, see the linked file for a possible solution...

The formulas used in the table:
D2: =IF(C5=9,IF(C4=9,IF(C3=9,IF(C2=9,1,C2+1),C2),C2),C2) (Range: D2:IRK2)
D3: =IF(C5=9,IF(C4=9,IF(C3=9,1,C3+1),C3),C3) (Range: D3:IRK3)
D4: =IF(C5=9,IF(C4=9,1,C4+1),C4) (Range: D4:IRK4)
D5: =IF(C5=9,1,C5+1) (Range: D5:IRK5)

Variations.xlsx