Generate random lines 3 numbers limit per line and 3 per column The matrix below 5x5

Generate random lines 3 numbers limit per line and 3 per column
The matrix below 5x5 = we have 5 columns and 5 rows
You have to generate all possible configurations at maximum limit
3 numbers per line and 3 for columns
= Example 05 15 35 22 21 24
Please
01 02 03 04 05
11 12 13 14 15
21 22 23 24 25
31 32 33 34 35
41 42 43 44 45

Excel 2010

Hi
See if is this you want
I use a sheet S_1 for helpers and S_2 for Results
Your matrix is in S_1!K1:O5
I used the following formula to find which decimal number has 3 values 1 in binary

Formula:

Please Login or Register  to view this content.

and use the formula

Formula:

Please Login or Register  to view this content.

to get the array {7;11;13;14;19;21;22;25;26;28}
Columns DEF has the following formula that gives the position of 1 in binary number to define lines and columns to use

Formula:

Please Login or Register  to view this content.

and Columns GHI

Formula:

Please Login or Register  to view this content.

The two following formulas are in S_2 Sheet to gives you the result (first three columns are rows elements, and the others are columns elements)

Formula:

Please Login or Register  to view this content.

Formula:

Please Login or Register  to view this content.

Your example are in row S_2!2289
See the file for clarification

ok hello jose, perfect, congratulations, very good job, thank you !!!! man!

Obrigado pelas amáveis palavras.

ok, muito JOSE, só mas isto na mesma planilia. um campo aonde eu digito ou seleciono os digitos ( 0,1,2,3,4,5,6,7,8,9) eu seleciono e a macro separa os digitos que selecionei ou marquei tipo um filtro
exemplo= digito ou seleciono nas formaçoes os digitos=last digit 4 e digit incial 3
14,24,44 31,32,34
tem que ter digit inicial e final para filtrar( nao vou usar todas as formaçoes so as filtradas
tem a lista de 0 a 9
porque temos outra matriz de 06 07 08 09 10....
mas é so trocar na mesma matriz da certo , so que preciso do filtro de dos 0,1,2,3,4,5,6,7,8,9
digito inicial e final colocar no link quando pronta
por favor . abraçoes

Hi
Please use English.
To place a global filter should put in cell S_2!G2 the following formula

Formula:

Please Login or Register  to view this content.

where I1 is the first digit of the number in columns A, B and C and J1 is the last digit of the number in columns D, E, and F.
You must choice 1 in that column.
See the file

OK sorry,!!!! very good job, perfect, thank you