Welcome Guest
Log In | Register )
You last visited December 8, 2016, 6:54 pm
All times shown are
Eastern Time (GMT-5:00)

macro

Topic closed. 2 replies. Last post 5 years ago by dr san.

Page 1 of 1
PrintE-mailLink
Avatar
bgonçalves
Brasil
Member #92564
June 9, 2010
2123 Posts
Offline
Posted: September 24, 2011, 10:05 am - IP Logged

Hello, it is possible to get a wheel to do so =   Separate the digits of the front and trailing digits.   Example of a lottery 60 / 6   First is the front of the digits from 0 to 4   After the final digit from 0 to 9 terminçao So I want to have a sum of The digit 1 appears 50 times (sum has to take into account the digit and the front end)   The second digit appears 30 times And so with other digits, separately or together sums   And macro   Tends to add up the digits of the draws already made   example 11,14,23,35,42,46 = Digit 1 = 3 times Digit 2 = 2 times Digit 3 = 2 times Digit 4 = 3 times   Digit 5 = 1 time   Digit 6 = once   7 digit = zero time   Digit 8 = zero time   Digito9 time = zero   Digit 0 = zero time   And so with the other results, making this the first statistical

    winsumloosesum's avatar - Lottery-060.jpg
    Pennsylvania
    United States
    Member #2218
    September 1, 2003
    5387 Posts
    Online
    Posted: September 26, 2011, 6:59 am - IP Logged

    You can set it up this way:

    For example, say you have your most current drawing in cell range E20 through J20 (11,14,23,35,42,46) 11 = E20, 14 = F20, 23 = G20, 35 = H20, 42 = I20, 46 = J20

    1. Insert the following formulas in cell range N20 through W20: (This will separate the front digits and back digits in cell range E20 through J20)

    Cell L20 - =INT($E20/10)

    Cell M20 - =INT(($E20-(L20*10))/1)

    ==========================

    Cell N20 - =INT($F20/10)

    Cell O20 - =INT(($F20-(N20*10))/1)

    ===========================

    Cell P20 - =INT($G20/10)

    Cell Q20 - =INT(($G20-(P20*10))/1)

    ===========================

    Cell R20 - =INT($H20/10)

    Cell S20 - =INT(($H20-(R20*10))/1)

    ===========================

    Cell T20 - =INT($I20/10)

    Cell U20 - =INT(($I20-(T20*10))/1)

    ===========================

    Cell V20 - =INT($J20/10)

    Cell W20 - =INT(($J20-(V20*10))/1)

    ===========================

    Next in cell range Y20 through AD20 enter the following formula:

    Cell Y20 - COUNTIF($L20:$W20,1)

    Cell Z20 - COUNTIF($L20:$W20,2)

    Cell AA20 - COUNTIF($L20:$W20,3)

    Cell AB20 - COUNTIF($L20:$W20,4)

    Cell AC20 - COUNTIF($L20:$W20,5)

    Cell AD20 - COUNTIF($L20:$W20,6)

    ================================

    Next in cell AF20 just enter the following formula:

    =Sum(Y20:AD20)

    ==================================

    Of course there may be an easier way to do this.

      Avatar
      bgonçalves
      Brasil
      Member #92564
      June 9, 2010
      2123 Posts
      Offline
      Posted: September 26, 2011, 8:12 am - IP Logged
      Hello, winsum, ok. good job, thanks,
      Winsu, beware of google translation, ok
      Was great the macro!, now I'll see how to find a reference!
      to see how to use the sums! ok, thanks, winsu