Welcome Guest
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
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

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)

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

Next in cell AF20 just enter the following formula:

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

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

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

 Page 1 of 1