LinkBack URL
About LinkBacks
How to create an algorithm to detect the first two numbers of a lottery?
goal = find results that starts
* with a double determine,
How to create an algorithm to detect the first two numbers of a lottery?
goal = find results that starts
* with a double determine,
Stating the obvious but if we could do that, we could also find the second two numbers, and the third two....etc. and if we could do all of that most of us would be billionaires sunning ourselves in our idyllic mansion on some private tropical pacific island
Please explain what you really mean.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
hello richard ok goal is to find
* in the lotteries pick 3,4,5,6,7
the first two numbers only
* these ex 49/6
first two numbers
* 05 12 9 first two numbers bet in ascending order´
* ex pick3 517 predict the digit 5,
but richard the algorithm
* will need to go to previous sweepstakes registration
ex = 49/6
02 05 23 25 36 48 = 02 05
03 12 15 26 32 41 = 03 12
10 12 16 25 32 45 = 10 12
.....
Sorry, but I just donlt understand your explanation and requirement
Please upload a workbook or a representative cut down copy, anonymised if necessary. It is always easier to advise if we can see your request in its context.
Show a before and after situation with manually calculated results, explaining which information is data and which is results, and if it's not blindingly obvious how you have arrived at your results some explanatory notes as well.
To upload a file click the Go Advanced button at the foot of your post, look underneath the post area for the Manage Attachments section and take it from there.
well we have left the list of all threes from 01 to 25
* there are 2300 in total,
* the macro will separate whose difference from the 1st digit
* to the 3rd digit of each crack the middle number does not enter = ex = 01 02 03 = difference is 2
the macro will only separate in the distances list
* of 2,3,4,5, there are other distances but only those mentioned do not enter the study = differences 2,3,4,5
* from 1st to 3rd digit of each triplet
hello RICHARD=https://www.excelforum.com/attachment.php?attachmentid=635717&stc=1&d=1564951471
Please attach the file properly.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hello Richard.
* separate only those with difference
* of the values = 2,3,4,5
https://www.excelforum.com/attachmen...1&d=1564952645
I, too, am uncertain exactly what you need the algorithm to do. Elements that I can see.
I5, O6, U7, and AC24 look like a simple subtraction formulas. I'm not sure whether these formulas should be based on the adjacent columns, or based on the first three columns. As a guess, I5 could be =$C5-$A5 (note the mix of relative and absolute references) and copied down column I and also copied into columns O, U, and AC.
Reading between the lines, it then appears that the goal is to copy from columns A:C into the adjacent columns based on that difference. This could be a simple IF() function. For example, E5 could be =IF($I5=$F$3,A5,"n/a") or something like that.
Is that close to what you are trying to do?
Originally Posted by shg
hello , MrShorty, ok perfect,
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks