5 position matrix from 00000 to 33333

[jorel]

5 position matrix from 00000 to 33333
ex=

00000
00001
00010
.......


33333

[Glenn Kennedy]

your explanation is too short.

[jorel]

Ok I'll show you an example,
This example macro. Warning is an example, okay?
But I need 00000 to 33333
Sub all_comb ()
'Macro to create all comb 0000-5555

Ln = 1 'start display at line 1
For w = 0 To 5: For x = 0 To 5: For y = 0 To 5: For z = 0 To 5
Cells (Ln, 1) = w: Cells (Ln, 2) = x: Cells (Ln, 3) = y: Cells (Ln, 4) = z
Ln = Ln + 1 'move down to next line
Next z: Next and: Next x: Next w 'complete loops

End Sub
I repeat to 0000-5555 is just a sample or example
I need to 5 positions 00000- 33333

[jorel]

Hello glenn, you could create a macro to generate several positions of two the 10 positions or be a field to enter the commands of several matrices and not only
Of 5 positions = 00000-33333
It's kind of a karnaugt map.

[Pete_UK]

So you want a list of those 5 digits going down column A, like this:

00000
00001
00002
00003
00010
00011
00012
00013
00020
00021

and so on, where only the digits 0, 1, 2 and 3 are used. Is that correct?

Pete

[jorel]

hello,PETE. Yes, perfect, this is correct, the last training will be 33333
It's kind of a karnaugt map.

[Pete_UK]

Put this formula in the first cell of your range:

=MOD(INT((ROWS($1:1)-1)/4^4),4) & MOD(INT((ROWS($1:1)-1)/4^3),4) & MOD(INT((ROWS($1:1)-1)/4^2),4) & MOD(INT((ROWS($1:1)-1)/4),4) & MOD(ROWS($1:1)-1,4)

then copy down. If your first cell is on row 1, you will need to copy down to row 1024 to get to 33333.

Hope this helps.

Pete

[jorel]

ok PETE,perfect,magnific, conglatulations, thank you man!!!

[Pete_UK]

You're welcome - thanks for the rep.

Pete