macro

Reply #2

dr san — Mon, 26 Sep 2011 12:12:48 GMT

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

Reply #1

winsumloosesum — Mon, 26 Sep 2011 10:59:41 GMT

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

macro

dr san — Sat, 24 Sep 2011 14:05:05 GMT

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,2... [ More ]