generate 12 numbers in each quadrant * without repeating the letter positions.

generate 12 numbers in each quadrant
* without repeating the letter positions
so I type in twelve numbers, any, within one of the quadrants, (will be generated 48 numbers in total), we have 4 quadrants in 4 colors,
I will choose, 12 numbers they become base not to repeat the other letters in the 3 quadrants,
* if I choose number 02 I can't play 07 52 57
* because it is the same letter or in the same position, as with the other 11 numbers
* objective = generate 12 random numbers in each quadrant, but cannot repeat from the same position
* reference or base quadrant
https://www.excelforum.com/attachmen...1&d=1565208698

will need a field where I type the 12 numbers of each quadrant, these numbers I will choose within each quadrant will become base, not to be the same letter

hello ok, I didn't realize this,
* my lottery has 100 numbers
* is drawn 20, 100/20 (lotomania)
ok can you do to respect as little as possible? you can see that in other lotteries
* where are drawn 6 numbers there works
so do to repeat few letters please

hello JeteMc =Phase A - base numbers

1. Choose 4 random letters of 25, assign them to 4 numbers from quadrant 1

2. Choose 4 random letters of remaining 21, assign them to 4 numbers from quadrant 2

3. Choose 4 random letters of remaining 17, assign them to 4 numbers from quadrant 3

4. Choose 4 random letters of remaining 13, assign them to 4 numbers from quadrant 4



Phase B - completing the game

1. Take the remaining 9 letters and assign them to corresponding numbers in each quadrant - you get 36 numbers

2. Choose 2 random numbers of these 36 to eliminate, you are left with 34 numbers

3. Combine these 34 numbers and the 16 base numbers to get a game of 50 numbers

ok, JETEMC but you need to create an algorithm for that, and I don't know how, but the goal is to avoid repeating the base number, I know you can repeat some, ko can do with repetitions ok

hello jete
1. Choose a random combination of 6 numbers from 25. (eg, 3,7,12,17,20,23) If you want 25 numbers, then you simply take all the 1 .. 25.

2. For each number, if the last digit is greater than 5 or equal to 0, you add 25. (7 -> 32,17 -> 42, so that the above example becomes 3,12,20,23,32,42) This way you obtain a random combination of 6 numbers in the first quadrant.

So, to answer your question, the numbers 3,12,20,23,32 and 42 are used as an example of a random combination in the first quadrant. They come from Step 2, quoted above. I've started with a random combination from 1..25 (Step 1), then added 25 where necessary to fit into the first quadrant. (Step 2, where 7 became 32 and 17 became 42, so that (3,7,12,17,20,23) becomes (3,32,12,42,20,23). Then I wrote it in an ascending order, perhaps you missed it because of that.

Originally Posted by jorel

Then I wrote it in an ascending order, perhaps you missed it

Should we guess without seeing as always any work ? Where is 'your' code ? Not here as it must be ! …

but the coordinates are there,
is not to repeat the letters !!!

hello wideboy, good job, you're correct, wide if i put more than one of 12 numbers
* example
I put 5 lines amcro do automatic?
ex =
02 05 06 ...... 12
45 89 23 ...... 12
75 20 12 ....... 12

hello,WIDE magnificent, work, now step 2, is to generate random, but never the couple polindromo together
* example 32 23 or 23 or 32 number both together in the same row
* there are in 00 to 99 45 pairs polindromes or inverted couple 01 10 12 21 25 52 98 89 .... 45 pairs
a couple of these can't show up together,
* another 89 98 or 89 or 98 number both together
* objective filter in random generation a couple number

hello i need to generate 120 lines
covering all numbers from 00 to 99
* with filter do not generate polindrome pair

Any clear sample ? As from the beginning the need always changes …

hello was given an example of a line and it worked, now i need 120 lines, can generate by filtering the polindrome pair, ex 29, 92
* within the lines of the 4 segments can not have the pair or 92 or 29 number together and so with the other pairs

An example : where ?!

ok, let's make it easier to generate random lines with 50 numbers, but you can't have one of the 45 possible
* from 00 to 99
so = 01 05 15 26 35 42 48 62 = oops can't have 62 because it's polindromo, capicuas or inverted couple, only one of them

45 =
01 10
02 20
03 30
04 40
05 50
06 60
07 70
08 80
09 90
12 21
13 31
14 41
23 32
15 51
24 42
25 52
34 43
16 61
17 71
26 62
35 53
37 73
28 82
19 91
38 83
56 65
39 93
49 94
58 85
67 76
59 95
68 86
69 96
79 97
89 98
18 81
27 72
36 63
45 54
47 74
46 64
29 92
38 83
78 87
68 86
49 94
57 75
48 84

11 22

33 44

55 66

77 88

99 00

above we have the list of 45 capicua or inverted pairs and the 10 pairs
* twins = 00 11 .... 99
* so how to generate lines of 50 numbers
* can't have 01 10 together or 78 89 just one of them

Whow ! Your list from "01 10" to "48 84" = 48 pairs not 45 ! Whatever …

But explain the second part from "11 22" to "99 00", what do you do with it ?

hello, ranging from 00 to 99 we have 45 polindrome pairs, and 10 twins
let's change!!! you will generate many random lines of 40 numbers (you can bet up to 50 numbers) lotomania (brazil), but these 40 numbers can't have a present pair of 45, only one number of it, ex or 23, or 32 numca together and so asos 45 then and I will fix the 10 twins =

Yes your post #19 list is wrong with 48 pairs !

Crystal clear explain the twins rules at least …

yes sorry for the list but it's 45 pairs
* 45 for 2 = 90 numbers plus 10 twins = togal 100 doubles from 00 to 99
don't worry about the twins will be fixed
* you have to scream 40 number lines without the pair capicuas

No as I have already solutions I won't code anything more, I just want all the rules and fixed, not to be changed,
in order to select the more appropriate …

ok you're correct so generate 40 number lines without the polindromo couple
* only one number of each couple numca the couple together
*

As I have to go to the swimming pool, you have an hour to well answer …

After a short explanation a little 10 years old boy - the son of a friend needing a mod in his laptop - found the errors in your list
then he explained the logic in order to generate the numbers in a row : I converted it with success to a 5 VBA codelines only.

ok you are correct, can you make the 5 line code? thank you

These five codelines just generate an unique 50 numbers row, is that all you need ?
I could share this child code as it is (later 'cause it's on another computer) but
are you able to amend it to fit your need as since more than a year you asked to generate numbers
so you already have all the necessary in your past threads, there is nothing new with these five codelines …

If you need a more targeted code, again it depends also on your complete explanation of rules (fixed)
(in particular for twins) or / and on an attachment with some results layout as I requested several times !

As I yet wrote : I already have several ways so I need answers in order to choose the appropriate way,
well read post #25 & 27 (like FDibbins as well, how can the truth be agressive ?!) …

hello, forget about the 10 twins, just focus on 45 pairs polindromos
* generate many numca formations with a pair along lines of 40 numbers
and other game, generate with pairs only
ex = 01 10 21 12 23 32
so we have two conditions generate lines with numbers forget twins
and generate only with pairs please

Again :

I'm still waiting for your attachment with the source pairs list and
at least a sample result for the layout desired about this new need …

hello, MARCL
https://www.excelforum.com/attachmen...1&d=1566127286

According to your attachment as a beginner starter :

PHP Code: 

Sub Demo40on45()
    Dim V, L%, W, C%, R%, N%(119, 39)
        V = [I1:BA2].Value2
        Randomize
    For L = 0 To 119
            W = [COLUMN(A:AS)]
        For C = 0 To 39
            R = Fix((45 - C) * Rnd) + 1
            N(L, C) = V(Fix(Rnd * 2) + 1, W(R))
            W(R) = W(45 - C)
        Next
    Next
        [A5:AN124].Value2 = N
End Sub 


Do you like it ? So thanks to click on bottom left star icon « ★ Add Reputation » !

hello, marc, uuhhh! perfect great job, congratulations, now can you create to generate only with peers? so we have 20 pairs on each line = ex = 02 20 23 32 ....... 40 numbers

As you do not like it just amend the C loop to 19 and with the R random index fill the array N with both value from the array V …

ok, Marc L, perfect, so I have both roles, great job, thanks MARC

Thanks for the rep' !

PHP Code: 

Sub Demo20pairs()
    Dim V, L%, W, C%, R%, N%(119, 39)
        V = [I1:BA2].Value2
        Randomize
    For L = 0 To 119
            W = [COLUMN(A:AS)]
        For C = 0 To 19
            R = Fix((45 - C) * Rnd) + 1
            N(L, C * 2) = V(1, W(R)):  N(L, 1 + C * 2) = V(2, W(R))
            W(R) = W(45 - C)
        Next
    Next
        [A5:AN124].Value2 = N
End Sub 


► Do you like it ? ► ► So thanks to click on bottom left star icon « ★ Add Reputation » !

ok correct, thank MARC L