I have included the last 4 games of lotofacil in Brasil. I am trying to look at the history of the games to try and filter for the next game.
1 2 3 5 9 0 1 2 3 5 0 1 3 4 5 This is the last game! (My conditional formatting shows 7 matched to the next 3 results)
1 3 4 8 9 0 3 4 5 6 7 0 1 3 4 these three were used to show the Digits Pattern for the game above.
1 2 4 5 7 9 0 2 3 4 6 7 8 9 2
2 3 4 5 6 7 8 1 3 4 6 0 1 3 4
I have an excel spreadsheet that is conditionally formatted to show me the last game to the three previous games. The formatting and count shows a value of 7 as the value that should produce a jackpot ticket. When I test this value by hiding the last game and filtering, then unhide the last game to see if the jackpot is in the remaining tickets, it is not there. I have completed the test to find the value needed to have the jackpot number in the tickets and it is 5 -- the problem is I do not understand how 5 is the value required for the jackpot when every thing I have shows the value 7 should have the jackpot after filtering. However, At least 5 to 5 positions must pass does give the jackpot ticket.
Does anyone have any idea why this filter functions in this manner. I thought maybe duplicates was an issue and maybe last digits of zero 0 could have something to do with it, but I can't seem to get to the right value for filtering.
Any help would be appreciated.
Thanks
Ralphj