Results 1 to 7 of 7

Thread: lottery 60/6

  1. #1

    lottery 60/6



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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.
    Start with a line:
    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.

  2. #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)

  3. #3
    Hello, I just need to activate the formula or make another

  4. #4
    can help me please activate and put in ok planilia

  5. #5
    or make a macro excel 2013!!?

  6. #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)

  7. #7
    hello, link=http://www.mediafire.com/view/r52e62ec5cvbcy5/para_bio.xlsx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •