1. ## lottery 60/6

If you want a combination of 6 two-digit numbers, that is 12 digits. So let's assume that you want 4 times 0, 3 times 1, 2 times 9 and 3 times 5, that is 12 all together. Now you need to arrange them into pairs to make numbers. I think that it will be easier to compose numbers 0..59, instead of 1..60, so in the end, you take 0 (i.e. 00) for 60.
0,0,0,0,1,1,1,5,5,5,9,9
Here, you only have 10 digits (0, 1 and 5) which qualify for the first digit in numbers below 60. So you first choose 6 digits to take positions of the first digit in each number.
For a start, you choose a random number from 1..10. E.g. you get 5. You have digit 1 in the place number 5 (marked red), so you take it out. That will be the first digit of your first number. What is left is this:

0,0,0,0,1,1,5,5,5,9,9

Now choose a random number from 1..9. E.g., you get 3, where you find digit 0, so the first digit for the second number is 0. This is now left:

0,0,0,1,1,5,5,5,9,9

Etc. Let's say that you end up fith the following digits: 1,0,5,1,5,0

So, now you are left with a sequence:

0,0,1,5,9,9

For the second digit, all digits qualify. So you now choose a random number from 1..6. E.g., you get 4, which gives you digit 5. Etc.

Let's say that in the end, your second sequence is 5,0,1,9,0,9. This gives you your final combination:

15,00,51,19,50,09

This one is OK, but it could happen that the same number appears twice, so you might need to swap the last digits of two numbers in the end.  Reply With Quote

2. Em H7 celular colocar a seguinte fórmula e arraste-o sobre a Q7 célula e para baixo, tanto quanto

T7 celular colocar a seguinte fórmula e arraste-o para AC7 célula e para baixo, tanto quanto necessário.
= LEN (H7)  Reply With Quote

3. Hello, I just need to activate the formula or make another  Reply With Quote

4. can help me please activate and put in ok planilia  Reply With Quote

5. or make a macro excel 2013!!?  Reply With Quote

6. In cell H7 put the following formula and drag it over to cell Q7 and down as far as needed.
=REPT(H\$5,12-LEN(SUBSTITUTE(RIGHT("00"&\$A7,2)&RIGHT("00"&\$B7,2)&RIGHT("00"&\$C7,2)&RIGHT("00"&\$D7,2)&RIGHT("00"&\$E7,2)&RIGHT("00"&\$F7,2),H\$5,"")))

In cell T7 put the following formula and drag it over to cell AC7 and down as far as needed.
=LEN(H7)  Reply With Quote  Reply With Quote