Results 1 to 7 of 7

Thread: lottery 60/6

  1. #1
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016

    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
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016
    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
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016
    Hello, I just need to activate the formula or make another

  4. #4
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016
    can help me please activate and put in ok planilia

  5. #5
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016
    or make a macro excel 2013!!?

  6. #6
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016
    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
    Seeker jorel's Avatar
    Join Date
    Jun 2014
    Posts
    7
    Articles
    0
    Excel Version
    2016
    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
  •