detect the last digit of each lottery, then add the quantity in each draw line.

**jorel** · 05-01-2020, 05:15 PM

detect the last digit of each lottery, then add the quantity in each draw line
* goal = to get a straight to play in all these lottery modes, if one of the straight, get at least 80% of a straight
of a lottery is already in profit
https://www.excelforum.com/attachmen...1&d=1588367715

**Paul** · 05-01-2020, 05:37 PM

Can be done using formulas...

In columns H:M, U:Y, AI:AO, AX:BC and BL:BQ you can just use =RIGHT(cell,1) formulas to get the last digit in each.

Then in BS6 you can use the formula:

Formula:

Please Login or Register  to view this content.

Fill that across to CB6 and then down as many rows as needed.

**jorel** · 05-01-2020, 06:24 PM

hello PAUL, very good work,
objective is to find a sequence
* of the last digit from 0 to 9 that at least is a drawn sequence of the last digit
* 80% or if it is a 6 digit lottery, hit 4
* already serves, for secondary prizes.
* great job, every week I will put new drawings

detect the last digit of each lottery, then add the quantity in each draw line.

LinkBack

Thread Tools

Rate This Thread

Display

detect the last digit of each lottery, then add the quantity in each draw line.

Re: detect the last digit of each lottery, then add the quantity in each draw line.

Re: detect the last digit of each lottery, then add the quantity in each draw line.

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] count the quantity of each of the 10 from 0 to 9 digits in the draw line

detect the corresponding sector numbers from 06 to 20 on each draw line

[SOLVED] detect the numbers on each draw line we both sectors and add the amount

[SOLVED] Only detect matching complete trios on each draw line.

[SOLVED] detect each corresponding number of the draw line.

in each draw line * detect the two empty quadruples

[SOLVED] separate the last digit from each draw line and add up to each * digit

Bookmarks

Bookmarks

Posting Permissions