- Home
- Premium Memberships
- Lottery Results
- Forums
- Predictions
- Lottery Post Videos
- News
- Search Drawings
- Search Lottery Post
- Lottery Systems
- Lottery Charts
- Lottery Wheels
- Worldwide Jackpots
- Quick Picks
- On This Day in History
- Blogs
- Online Games
- Premium Features
- Contact Us
- Whitelist Lottery Post
- Rules
- Lottery Book Store
- Lottery Post Gift Shop
The time is now 2:55 pm
You last visited
May 6, 2024, 2:29 pm
All times shown are
Eastern Time (GMT-5:00)
Find lotteries Repetitions patterns on past resultsPrev TopicNext Topic
-
Almost completed a excel macro that Finds lotteries Repetitions patterns on past results. the output looks like this
the look for 5 numbers patterns out of 37 numbers output looks like this after the macro runs :
(((note ::: this is only part of the output looks like )))
Rows 2 and 20 have repetitions 6 11 13 26 28 Rows 2 and 70 have repetitions 6 16 26 28 29 31 34 Rows 2 and 118 have repetitions 11 13 26 29 31 Rows 2 and 176 have repetitions 10 11 26 28 31 Rows 2 and 198 have repetitions 6 10 16 26 29 Rows 2 and 212 have repetitions 6 10 26 28 29 34 Rows 2 and 235 have repetitions 10 11 13 26 31 34 Rows 2 and 260 have repetitions 6 10 11 28 31 34 Rows 2 and 269 have repetitions 6 10 26 28 29 Rows 2 and 286 have repetitions 6 10 11 28 29 Rows 2 and 309 have repetitions 6 13 26 28 29 34 Rows 2 and 318 have repetitions 6 13 16 26 28 Rows 2 and 360 have repetitions 6 10 13 26 28 29 Rows 2 and 390 have repetitions 10 11 16 26 28 Rows 2 and 393 have repetitions 10 11 13 26 29 31 Rows 2 and 419 have repetitions 16 26 28 29 31 Rows 2 and 443 have repetitions 6 16 28 29 31 Rows 2 and 487 have repetitions 11 13 16 26 28 34 Rows 2 and 490 have repetitions 10 13 26 29 31 Rows 2 and 512 have repetitions 6 10 11 28 29 31 Rows 2 and 537 have repetitions 10 13 16 29 31 Rows 2 and 552 have repetitions 6 13 16 26 28 31 Rows 2 and 582 have repetitions 6 10 13 16 29 Rows 2 and 598 have repetitions 6 10 16 26 31 Rows 2 and 607 have repetitions 10 11 16 28 29 Rows 2 and 697 have repetitions 6 10 13 16 28 Rows 2 and 704 have repetitions 10 11 26 28 29 Rows 2 and 731 have repetitions 11 13 16 26 28 31 Rows 2 and 750 have repetitions 6 10 11 13 31 34 Rows 2 and 754 have repetitions 6 13 16 28 29 Rows 2 and 755 have repetitions 6 10 16 26 31 34 Rows 2 and 778 have repetitions 13 26 28 29 31 34 Rows 2 and 790 have repetitions 10 16 28 29 31 Rows 2 and 796 have repetitions 6 11 13 16 26 31 Rows 2 and 800 have repetitions 11 16 26 28 31 34 Rows 2 and 824 have repetitions 6 11 13 28 29 31 Rows 3 and 26 have repetitions 2 3 5 10 32 Rows 3 and 35 have repetitions 2 3 10 22 26 30 37 Rows 3 and 38 have repetitions 2 3 5 10 32 37 Rows 3 and 55 have repetitions 3 5 7 22 26 Rows 3 and 62 have repetitions 2 10 26 30 32 37 Rows 3 and 66 have repetitions 2 7 22 30 32 Rows 3 and 77 have repetitions 3 7 26 30 32 37 Rows 3 and 81 have repetitions 2 5 7 10 26 Rows 3 and 86 have repetitions 3 5 22 30 32 Rows 3 and 123 have repetitions 2 3 7 10 30 Rows 3 and 155 have repetitions 3 5 10 30 32 Rows 3 and 174 have repetitions 3 5 7 22 30 32 Rows 3 and 210 have repetitions 2 7 10 26 32 37 Rows 3 and 220 have repetitions 2 3 5 10 30 Rows 3 and 231 have repetitions 2 10 22 26 30 Rows 3 and 280 have repetitions 3 5 7 22 30 Rows 3 and 284 have repetitions 2 3 5 26 32 Rows 3 and 295 have repetitions 2 3 5 26 30 37 Rows 3 and 334 have repetitions 2 5 7 22 26 32 Rows 3 and 352 have repetitions 2 3 5 22 26 Rows 3 and 400 have repetitions 3 5 26 30 32 Rows 3 and 501 have repetitions 2 7 10 22 26 30 32 Rows 3 and 524 have repetitions 10 22 26 30 32 Rows 3 and 528 have repetitions 3 5 7 10 30 Rows 3 and 569 have repetitions 5 22 26 30 32 Rows 3 and 571 have repetitions 3 7 10 22 30 Rows 3 and 574 have repetitions 3 5 10 30 32 Rows 3 and 625 have repetitions 2 3 7 10 22 Rows 3 and 649 have repetitions 2 5 22 26 32 Rows 3 and 693 have repetitions 2 3 5 22 26 Rows 3 and 705 have repetitions 3 10 22 30 32 Rows 3 and 771 have repetitions 3 7 10 22 26 Rows 3 and 798 have repetitions 2 3 5 7 10 26 Rows 4 and 27 have repetitions 5 11 12 16 21 25 Rows 4 and 32 have repetitions 5 7 9 12 13 Rows 4 and 40 have repetitions 5 7 12 16 21 Rows 4 and 59 have repetitions 5 11 12 13 16 Rows 4 and 64 have repetitions 5 7 9 12 16 Rows 4 and 75 have repetitions 7 9 11 12 17 Rows 4 and 103 have repetitions 7 11 13 17 21 Rows 4 and 119 have repetitions 7 9 12 13 16 Rows 4 and 175 have repetitions 11 12 13 16 21 Rows 4 and 230 have repetitions 5 11 16 17 21 25 Rows 4 and 244 have repetitions 5 7 9 13 16 21 Rows 4 and 255 have repetitions 5 7 12 16 21 Rows 4 and 281 have repetitions 5 9 16 17 21 Rows 4 and 298 have repetitions 5 7 9 12 21 Rows 4 and 311 have repetitions 5 7 9 13 16 Rows 4 and 312 have repetitions 5 9 11 12 13 21 25 Rows 4 and 317 have repetitions 9 11 12 16 17 21 Rows 4 and 322 have repetitions 5 9 11 12 17 21 Rows 4 and 351 have repetitions 5 11 13 16 17 Rows 4 and 370 have repetitions 7 11 12 16 17 Rows 4 and 390 have repetitions 9 11 12 16 17 25 Rows 4 and 393 have repetitions 5 9 11 13 17 Rows 4 and 454 have repetitions 7 12 13 16 17 Rows 4 and 507 have repetitions 5 13 16 17 21 Rows 4 and 522 have repetitions 5 11 12 16 17 21 Rows 4 and 540 have repetitions 5 9 11 13 16 Rows 4 and 551 have repetitions 12 13 16 17 21 Rows 4 and 593 have repetitions 5 13 16 17 21 Rows 4 and 625 have repetitions 7 9 11 12 16 17 Rows 4 and 629 have repetitions 9 12 13 16 17 Rows 4 and 635 have repetitions 5 11 12 13 16 25 Rows 4 and 702 have repetitions 5 7 11 13 16 21 Rows 4 and 712 have repetitions 7 12 13 16 17 Rows 4 and 721 have repetitions 5 9 11 12 21 Rows 4 and 770 have repetitions 7 11 12 13 17 Rows 4 and 792 have repetitions 5 7 12 16 17 Rows 4 and 793 have repetitions 5 9 11 13 21 Rows 4 and 797 have repetitions 7 11 13 17 21 Rows 4 and 820 have repetitions 9 12 13 17 21 Rows 5 and 6 have repetitions 1 6 9 10 32 Rows 5 and 22 have repetitions 1 3 10 14 25 33 Rows 5 and 28 have repetitions 9 14 15 25 32 Rows 5 and 43 have repetitions 3 9 15 25 32 33 Rows 5 and 89 have repetitions 1 3 9 14 15 Rows 5 and 122 have repetitions 1 3 6 9 10 Rows 5 and 160 have repetitions 3 6 9 15 32 33 Rows 5 and 161 have repetitions 6 9 14 15 25 32 Rows 5 and 180 have repetitions 1 3 9 15 32 33 Rows 5 and 200 have repetitions 1 3 6 14 32 33 Rows 5 and 212 have repetitions 1 6 10 14 15 Rows 5 and 257 have repetitions 1 3 6 10 15 33 Rows 5 and 297 have repetitions 1 3 6 15 32 Rows 5 and 329 have repetitions 1 6 10 15 32 Rows 5 and 346 have repetitions 6 9 10 14 25 33 Rows 5 and 350 have repetitions 1 3 9 10 25 Rows 5 and 361 have repetitions 1 3 9 10 15 Rows 5 and 445 have repetitions 1 6 9 10 15 Rows 5 and 456 have repetitions 9 10 14 15 32 33 Rows 5 and 502 have repetitions 3 6 14 25 32 Rows 5 and 559 have repetitions 6 9 10 14 25 Rows 5 and 697 have repetitions 1 3 6 10 32 Rows 5 and 739 have repetitions 6 9 14 15 25 33 Rows 5 and 753 have repetitions 1 9 10 15 32 33 Rows 5 and 802 have repetitions 6 10 15 25 32 Rows 5 and 803 have repetitions 3 6 10 15 25 33 Rows 5 and 808 have repetitions 6 10 14 25 32 33 Rows 5 and 825 have repetitions 3 9 14 15 32 33 Rows 6 and 28 have repetitions 5 9 13 20 22 32 Rows 6 and 157 have repetitions 5 6 9 10 13 Rows 6 and 213 have repetitions 1 9 10 20 32 Rows 6 and 216 have repetitions 1 5 6 13 22 Rows 6 and 242 have repetitions 5 6 10 13 22 Rows 6 and 250 have repetitions 6 9 10 13 20 37 Rows 6 and 278 have repetitions 1 5 6 10 20 37 Rows 6 and 287 have repetitions 1 5 6 9 32 Rows 6 and 329 have repetitions 1 6 10 20 32 Rows 6 and 333 have repetitions 5 9 10 20 22 Rows 6 and 355 have repetitions 1 5 6 20 32 Rows 6 and 377 have repetitions 1 6 10 20 22 Rows 6 and 413 have repetitions 1 5 20 22 32 Rows 6 and 445 have repetitions 1 5 6 9 10 Rows 6 and 463 have repetitions 1 6 13 20 32 Rows 6 and 471 have repetitions 1 5 10 20 22 Rows 6 and 580 have repetitions 1 5 9 20 22 37 Rows 6 and 592 have repetitions 5 9 13 20 32 Rows 6 and 593 have repetitions 1 5 6 13 32 Rows 6 and 623 have repetitions 1 9 10 13 22 Rows 6 and 683 have repetitions 1 5 9 10 13 20 22 Rows 6 and 697 have repetitions 1 6 10 13 32 Rows 6 and 703 have repetitions 5 13 20 22 32 Rows 6 and 705 have repetitions 6 10 13 22 32 Rows 6 and 729 have repetitions 9 10 20 22 32 Rows 6 and 751 have repetitions 1 6 9 10 13 20 22 Rows 6 and 753 have repetitions 1 9 10 22 32 37 Rows 6 and 772 have repetitions 1 5 9 13 20 Rows 6 and 777 have repetitions 1 5 6 13 32 37 Rows 6 and 791 have repetitions 1 5 13 22 32 Rows 6 and 793 have repetitions 5 9 13 22 32 Rows 7 and 11 have repetitions 2 6 7 9 12 23 Rows 7 and 39 have repetitions 2 6 7 9 12 Rows 7 and 41 have repetitions 6 9 12 23 35 Rows 7 and 65 have repetitions 7 11 12 14 23 Rows 7 and 75 have repetitions 6 7 9 11 12 Rows 7 and 108 have repetitions 7 11 12 14 23 36 Rows 7 and 140 have repetitions 2 6 7 9 23 Rows 7 and 142 have repetitions 2 6 11 12 14 Rows 7 and 169 have repetitions 2 7 11 14 35 Rows 7 and 190 have repetitions 2 7 9 11 14 35 Rows 7 and 232 have repetitions 9 11 12 23 35 36 Rows 7 and 260 have repetitions 6 7 11 12 35 Rows 7 and 273 have repetitions 7 9 12 14 35 36 Rows 7 and 294 have repetitions 6 7 9 11 14 Rows 7 and 322 have repetitions 9 11 12 14 35 Rows 7 and 368 have repetitions 2 6 11 12 23 Rows 7 and 404 have repetitions 2 6 12 14 23 Rows 7 and 411 have repetitions 7 9 11 23 35 Rows 7 and 412 have repetitions 2 11 12 14 35 Rows 7 and 422 have repetitions 2 6 11 14 23 36 Rows 7 and 473 have repetitions 6 9 12 14 23 Rows 7 and 577 have repetitions 6 7 9 14 23 Rows 7 and 625 have repetitions 2 7 9 11 12 Rows 7 and 626 have repetitions 2 7 11 23 35 Rows 7 and 676 have repetitions 7 9 12 14 35 Rows 7 and 736 have repetitions 2 7 9 14 35 Rows 7 and 779 have repetitions 7 11 12 14 35 Rows 7 and 816 have repetitions 6 7 11 23 35 Rows 7 and 831 have repetitions 6 7 12 14 35 36 Rows 8 and 42 have repetitions 5 16 17 22 30 Rows 8 and 86 have repetitions 5 17 22 23 30 Rows 8 and 90 have repetitions 9 16 17 22 24 Rows 8 and 121 have repetitions 16 17 22 23 24 Rows 8 and 125 have repetitions 5 10 22 23 24 Rows 8 and 146 have repetitions 5 9 10 16 17 23 Rows 8 and 157 have repetitions 5 9 10 23 30 Rows 8 and 177 have repetitions 5 10 17 23 24 34 Rows 8 and 220 have repetitions 5 9 10 16 23 30 Rows 8 and 231 have repetitions 10 17 22 23 24 30 Rows 8 and 333 have repetitions 5 9 10 22 30 Rows 8 and 337 have repetitions 5 10 17 22 23 Rows 8 and 357 have repetitions 5 9 17 24 30 Rows 8 and 386 have repetitions 10 16 22 23 30 34 Rows 8 and 391 have repetitions 5 9 16 17 23 Rows 8 and 401 have repetitions 10 16 17 23 24 Rows 8 and 446 have repetitions 5 16 22 23 24 34 Rows 8 and 472 have repetitions 9 10 22 23 24 Rows 8 and 524 have repetitions 10 16 22 23 30 Rows 8 and 562 have repetitions 5 9 16 22 23 Rows 8 and 565 have repetitions 17 22 23 24 30 Rows 8 and 612 have repetitions 9 22 23 24 30 Rows 8 and 623 have repetitions 9 10 22 23 24 Rows 8 and 625 have repetitions 9 10 16 17 22 Rows 8 and 652 have repetitions 5 16 22 23 24 Rows 8 and 657 have repetitions 16 22 23 24 30 34 Rows 8 and 669 have repetitions 10 16 22 23 24 Rows 8 and 683 have repetitions 5 9 10 17 22 Rows 8 and 684 have repetitions 10 17 23 24 30 34 Rows 8 and 688 have repetitions 10 17 23 24 30 Rows 8 and 766 have repetitions 5 9 16 22 24 34 Rows 8 and 826 have repetitions 5 9 10 22 23 34 Rows 9 and 10 have repetitions 18 20 24 29 30 36 Rows 9 and 121 have repetitions 16 20 23 24 25 Rows 9 and 132 have repetitions 18 20 23 24 25 Rows 9 and 209 have repetitions 16 18 20 23 30 Rows 9 and 211 have repetitions 16 20 25 29 30 Rows 9 and 228 have repetitions 16 18 24 25 30 Rows 9 and 258 have repetitions 20 23 25 26 29 Rows 9 and 291 have repetitions 16 20 24 25 26 36 Rows 9 and 338 have repetitions 16 18 25 29 30 Rows 9 and 340 have repetitions 16 20 23 25 30 Rows 9 and 384 have repetitions 18 20 24 26 29 Rows 9 and 419 have repetitions 16 20 25 26 29 36 Rows 9 and 426 have repetitions 16 20 23 24 26 Rows 9 and 478 have repetitions 18 20 24 29 30 Rows 9 and 490 have repetitions 18 20 24 26 29 Rows 9 and 501 have repetitions 16 18 26 29 30 Rows 9 and 514 have repetitions 16 20 24 29 30 Rows 9 and 631 have repetitions 16 18 23 24 25 29 Rows 9 and 647 have repetitions 18 23 24 26 30 36 Rows 9 and 652 have repetitions 16 18 23 24 29 Rows 9 and 657 have repetitions 16 23 24 25 30 36 Rows 9 and 688 have repetitions 20 23 24 26 30 Rows 9 and 713 have repetitions 23 24 25 29 30 Rows 9 and 715 have repetitions 18 23 25 26 29 Rows 9 and 723 have repetitions 18 23 24 25 29 36 Rows 9 and 795 have repetitions 16 18 20 23 30 Rows 9 and 813 have repetitions 16 18 23 24 29 30 Rows 9 and 822 have repetitions 16 18 23 24 25 Rows 10 and 20 have repetitions 13 20 24 30 36 Rows 10 and 56 have repetitions 13 18 20 29 30 32 Rows 10 and 95 have repetitions 13 18 20 32 36 Rows 10 and 139 have repetitions 13 20 24 31 36 Rows 10 and 143 have repetitions 13 18 30 31 36 Rows 10 and 159 have repetitions 13 18 20 24 36 37 Rows 10 and 164 have repetitions 13 20 30 31 36 Note 2 ::: this macro will only work on windows pc with MS excel 2010 above , open office wont work ,,,,
-
ok here is the vba code so far :::
Public Sub Highlight_Repetitions()
REPEATS = Application.InputBox("How many numbers would you like to find Repetitions:", Type:=1)
Dim Rw1 As Range, Rw2 As Range
Dim check_array As Variant, match_array As Variant
Sheets("sheet1").Select
Application.Calculation = xlCalculationManual
Range("a1:t1").Select ' first draw (first 5 balls)Do While ActiveCell.Value <> 0
Selection.Offset(1, 0).Select
Selection.Sort Key1:=ActiveCell, Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase:=False, Orientation:=xlLeftToRight
Loop
Application.Calculation = xlCalculationAutomatic
Range("u1").Select 'scroll back to new result
Dim Shex As Object
Set Shex = CreateObject("Shell.Application")
tgtfile = "C:\temp\ke1.csv"
On Error Resume Next
Kill "C:\temp\ke1.csv"
On Error GoTo 0
For Each Rw1 In [Numbers].Rows
If Rw1.Row >= [Numbers].Rows.Count \ 2 Then Exit For
check_array = Rw1.Value
For Each Rw2 In [Numbers].Rows
If Rw2.Row > Rw1.Row Then
match_array = Rw2.Value
repetitions = 0
repeat_string = vbNullString
For i = LBound(check_array, 2) To UBound(check_array, 2)
If i <= REPEATS + repetitions Then
For j = LBound(match_array, 2) To UBound(match_array, 2)
If check_array(1, i) = match_array(1, j) Then
repetitions = repetitions + 1
repeat_string = repeat_string & check_array(1, i) & " , "
End If
Next
Else
Exit For
End If
Next
If repetitions >= REPEATS Then
Open "C:\temp\ke1.csv" For Append As #1
'MsgBox "Rows " & Rw2.Row & " and " & Rw1.Row & " have repetitions"
'MsgBox "Rows " & Rw1.Row & " and " & Rw2.Row & " have repetitions" & " , " & repeat_string
Print #1, "Rows " & Rw1.Row & " and " & Rw2.Row & " have repetitions " & " , " & repeat_string
'Print #1, Rw1.Row; " , " & repeat_string
'Print #2, repeat_string
Close #1
End If
End If
Next
Next
Shex.Open (tgtfile)
End Sub -
I tried to run it and got error "Run time error '424' Object required?
Debug error points to => For Each Rw1 In [Numbers].Rows
-
hi TooTallLuke you have to Create a named range called Numbers , i have uploaded an example for you
-
Thank you Timmsy, good stuff. Would explain again how to use this program? I am still getting a run time error. Please explain briefly on Numbers range.
Thank you,
Good Luck everyone
-
Works really well, thanks
-
Anyone picked winning numbers using this Excel macro yet ?