Match Winning Numbers
Posted: Wed Jun 15, 2022 7:20 pm
I cannot get this filter to work and notice there is now additional columns (Min and Max) that are not covered in the manual. What ever combination I try the Maths does not seem to work.
I would like to get the ticket package to reject any ticket that has 2, 3 , 4 or 5 of the numbers that also appeared in the last 20 winning games
Example last 5 Winning Game Numbers:
10-Jun-2022 19 25 31 32 42
11-Jun-2022 18 33 38 41 42
12-Jun-2022 2 6 10 22 26
13-Jun-2022 15 19 20 25 29
14-Jun-2022 3 10 16 17 35
Ticket Package
1 4 10 23 35 Reject as has 10 and 35
1 6 10 23 35 Reject as has 6 and 10
1 8 10 23 35 Reject as has 10 and 35
1 10 11 23 35 Reject as has 10 and 35
1 10 23 31 35 Reject as has 10 and 35
2 4 6 8 10 Reject as has 2 and 6 and 10
2 4 6 8 31 Reject as has 2 and 6
2 4 6 10 11 Reject as has 2 and 6
2 4 6 10 23 Reject as has 2 and 6
2 4 6 10 31 Reject as has 2 and 6
2 4 6 10 35 Reject as has 2 and 6
2 4 8 10 31 Accept as only has one number (10)
7 9 12 26 34 Accept as only has one number (26)
7 9 13 27 40 Accept as no numbers from winning numbers
Any suggestions welcome. Thanks
I would like to get the ticket package to reject any ticket that has 2, 3 , 4 or 5 of the numbers that also appeared in the last 20 winning games
Example last 5 Winning Game Numbers:
10-Jun-2022 19 25 31 32 42
11-Jun-2022 18 33 38 41 42
12-Jun-2022 2 6 10 22 26
13-Jun-2022 15 19 20 25 29
14-Jun-2022 3 10 16 17 35
Ticket Package
1 4 10 23 35 Reject as has 10 and 35
1 6 10 23 35 Reject as has 6 and 10
1 8 10 23 35 Reject as has 10 and 35
1 10 11 23 35 Reject as has 10 and 35
1 10 23 31 35 Reject as has 10 and 35
2 4 6 8 10 Reject as has 2 and 6 and 10
2 4 6 8 31 Reject as has 2 and 6
2 4 6 10 11 Reject as has 2 and 6
2 4 6 10 23 Reject as has 2 and 6
2 4 6 10 31 Reject as has 2 and 6
2 4 6 10 35 Reject as has 2 and 6
2 4 8 10 31 Accept as only has one number (10)
7 9 12 26 34 Accept as only has one number (26)
7 9 13 27 40 Accept as no numbers from winning numbers
Any suggestions welcome. Thanks