Randon formations 5 numbers per row and 5 per columns, Without repeating the letter posit

[jorel]

Randon formations 5 numbers per row and 5 per columns,
Without repeating the letter positions. That is in the matrix of 10 x 10
Create formations that at the same time are 5 per line and 5 per columns, formations of 50 numbers
But without repeating the letters 01 06 51 56, it can not, because they are all numbers of the letters A. or tolerance of at most to repeat a letter,
01 02 03 04 05 06 07 08 09 10
11 12 13 14 15 16 17 18 19 20
21 22 23 24 25 26 27 28 29 30
31 32 33 34 35 36 37 38 39 40
41 42 43 44 45 46 47 48 49 50


51 52 53 54 55 56 57 58 59 60
61 62 63 64 65 66 67 68 69 70
71 72 73 74 75 76 77 78 79 80
81 82 83 84 85 86 87 88 89 90
91 92 93 94 95 96 97 98 99 00
a b c d e a b c d e
f g h i j f g h i j
k l m n o k l m n o
p q r s t p q r s t
u v w x y u v w x y

a b c d e a b c d e
f g h i j f g h i j
k l m n o k l m n o
p q r s t p q r s t
u v w x y u v w x y

[jorel]

corret positions nunbers the letters
http://www.mediafire.com/file/cqun6p..._corretas.xlsx

[jorel]

In the first post the numbers and the letters were left of the positions
The correct one is in the syllabus link!
There are 4 groups of 25 (5x5) or 25 letters
In order to see the positions of the 4 sectors
Not to repeat in the formations
Then, random lines will have 50 numbers,
In the criteria of 5 by lines and 5 by columns without repeating the letters
With the tolerance of repeating a letter or position

[jorel]

please!!!!

[karedog]

Hi jorel,

Please download my file (because in your file, you don't split the items into individual cells), and run the macro, see if this is what you want.

Please Login or Register  to view this content.

[jorel]

ok, karedog
For i = 2 To 4
arrTemp1 = arrNum(i)
arrTemp2 = arrLtr(i)
For j = 2 To i
ShiftRight arrTemp1: ShiftDown arrTemp1
ShiftRight arrTemp2: ShiftDown arrTemp2
Next j
arrNum(i) = arrTemp1
arrLtr(i) = arrTemp2

[karedog]

Hi jorel, why do you highlight the "arrTemp1 = arrNum(i)" line ?
Is any error occurred ?

[jorel]

hello , karedog Yes,yes!!! an error occurred my system is windows 10, 64 bit,
The random formations, will be lines of 50 numbers
Can generate 250 to 1000 formations or more.
Tolerance of repeating a position in the case a letter

[jorel]

Karedog, rows and columns in array
Are 10 numbers, are separated to show the letters
And their positions, or, whether the macro has see the line 10 numbers and the column of 10 numbers,

[karedog]

The code is using pure array methods, so operating system has no relevance here (any OS is fine).
Remember, you must run the macro on my file, not on your file, because you haven't split the data into individual cells like in my file.

[jorel]

Hello, there are many formations of 50 numbers, in the criteria of maximum 5 per line and 5 columns without repeating the positions
Example xxxxx xxxxx xxxxx ................................... 50 numbers
Are lines with 50 numbers in the cited filter criteria

[jorel]

Karedog, we have a problem, the 5 numbers of the columns have to be scattered in the 10 numbers of the column and in the line in the same way, there can be no sequence of 5 numbers
You have to use the 10 numbers in both the row and the column.

[jorel]

exemplo=02 05 07 08 10 03 23 33 73 93.........50 numbers lines

[jorel]

Karedog, when the macro created the random line of 50 numbers has to take into account the 4 positions of the letters, as a ten is the reference we have the other 3 letters that can not repeat

[karedog]

I don't understand. Can you upload a sample file with your manual calculation result, with some notes to describe why this is allowed, why this is not allowed, etc ... ?

[jorel]

the corret =ttp://www.mediafire.com/file/gl9dmrmey8s1947/EF1165580b%283%29.xls

[jorel]

Hello kaREDOG, sorry, there are 4 macros, a macro every quadrant
One macro for the green quadrant, one for blue, one for red, and one for yellow = 4 parts
Karedog, when the green quadrant is a reference, or the base, can repeat the letters of the other three quadrants as shown by the example of the highlighted edges
When the fixed reference is the blue quadrant it can not repeat the letters
And so with the red and yellow quadrants
We have 4 macros
Another example = when the base or fixed reference is quadrant 4 (yellow)
You can not repeat the positions of the letters of the rest, which is the pattern that is drawn in the
Drawings, not repeating positions
Then five per line 10 and 5 per column without repeating the letters of the base quadrant
In each macro generate some 300 formations. Please

[jorel]

Hello you must use each of the 4 quadrants as a fixed reference
For the remaining three (quadrants) do not repeat the letters
And five by 10 and 5 numbers per 10 column of the 10x10 matrix

[jorel]

Kare, are symmetrical formations. Obeying criteria
From 5 numbers per column and 5 numbers per row from the 10x10 matrix
And when a quadrant is the reference or fixed base the remaining 3
Quadrants do not repeat the letters, so we have two conditions, in each macro
Needs 4 macros, one macro every quadrant base

[jorel]

Kare, the edge highlighting example
Because it repeats from the base quadrant

[jorel]

hello karedog??

[jorel]

hello Karedog, which part did not understand ????

[karedog]

jorel,

I am more confused than before.

You said that duplicate letters are not allowed, but your manual calculation on sheet Plan1, you marked 23, 28, 73, 78, they are all have same letter (m), but you still marked them.

However, this is what I have done. If this is still not what you expected, then you must wait someone else who can understand what your real question is and your requirements.

Please download my attached file, then :
- to do a single calculation, run macro "MAIN", or press the command button on sheet "Plan2"
- to do 300 calculations (as you wish), run macro "Generate300", the output will be written to sheet "Plan3"

Please Login or Register  to view this content.

[jorel]

Okay, KAREDOG[/SUB]dog. Can not repeat the letters, but I marked in detail
From the edges, there it was only to show the first part of five by column and five line
So much that I highlighted the edges, I tried to give an example, to show the two conditions
The last file is correct, but it is necessary to correct not repeating the letters of the quadrant
Base, we have 4 bases, one base each quadrant
Karedog, I put the example of the symmetrical ones and I marked with the edges
To show that you should not repeat, you must now correct not to repeat
The letters, and to have each of the quadrant 4 the base, please, when you win
A good prize, will be rewarded with 20%
Sometimes it takes time to respond because of the time zone

Only you can see you can do it, it was only a misunderstanding, you have great capacity, now you have to correct
The positions, and correct the base quadrant
Watch out for Google translate, please

[jorel]

Okay, karedog. Can not repeat the letters, but I marked in detail
From the edges, there it was only to show the first part of five by column and five line
So much that I highlighted the edges, I tried to give an example, to show the two conditions
The last file is correct, but it is necessary to correct not repeating the letters of the quadrant
Base, we have 4 bases, one base each quadrant
Karedog, I put the example of the symmetrical ones and I marked with the edges
To show that you should not repeat, you must now correct not to repeat
The letters, and to have each of the quadrant 4 the base, please, when you win
A good prize, will be rewarded with 20%
Sometimes it takes time to respond because of the time zone

Only you can see you can do it, it was only a misunderstanding, you have great capacity, now you have to correct
The positions, and correct the base quadrant
Watch out for Google translate, please

[jorel]

Sorry, karedog, was to show the first part of the timing
But, I highlight the edges !!!!, your last file is correct, in the first phase
Just need to correct the positions of the letters, that example was to show the rows and columns only, sorry. You have base of the quadrant 1,2,3,4 is in 4 editions
Based on a quadrant at a time not to repeat the letters that is what happens in the raffles.please

[jorel]

Karedog if possible also put these conditions
Of course not to repeat the lyrics
5 NUMBERS IN EACH COLUMN
5 numbers in EACH LINE
25 numbers PAIRS AND 25 ODD NUMBERS
25 NUMBER OF TOP OF THE STEERING WHEEL AND 25 NUMBERS IN THE PART OF LOW
25 numbers NA HALF LEFT HANDLE 25 AND RIGHT HANDLE
Kerdog please

[karedog]

As I said earlier, I really don't understand your requirements. No duplicates at all in 3 quadrants is impossible, unless I misinterpret again your words.
That is why I asked you to provide a CORRECT samples what the output should be, so I can "guess" what you actually meaned, but found out that you give INCORRECT samples.
How can I understand your requirements, if you give the INCORRECT samples ?
If writing in English is a barrier for you, you can make a post in non english subforum : http://www.excelforum.com/non-english-excel/
You can describe your problem better there, using your native language, and somebody who understand will handle it.

[jorel]

Karedog if possible also put these conditions
Of course not to repeat the lyrics
5 NUMBERS IN EACH COLUMN
5 numbers in EACH LINE
25 numbers PAIRS AND 25 ODD NUMBERS
25 NUMBER OF TOP OF THE STEERING WHEEL AND 25 NUMBERS IN THE PART OF LOW
25 numbers NA HALF LEFT HANDLE 25 AND RIGHT HANDLE
Kerdog please