2/01/2010 2 4 8 11 37 39
6/01/2010 1 5 8 19 24 29
9/01/2010 8 9 13 14 30 38
13/01/2010 7 17 24 32 33 34
16/01/2010 25 26 28 29 30 33
20/01/2010 1 4 9 15 34 40
23/01/2010 2 16 21 25 30 33
27/01/2010 15 23 24 30 36 42
30/01/2010 19 20 24 33 34 42
3/02/2010 11 12 23 26 31 36
6/02/2010 16 19 24 29 30 31
10/02/2010 2 12 13 35 36 41
13/02/2010 3 4 10 14 18 41
17/02/2010 3 13 15 22 27 37
20/02/2010 9 18 19 25 31 34
24/02/2010 22 27 29 31 34 37
27/02/2010 1 11 12 27 32 33
3/03/2010 4 8 14 15 33 35
7/03/2010 1 8 10 28 32 40
13/03/2010 7 9 20 23 40 42
17/03/2010 7 12 19 24 35 38

is there any excel macro to find this replay numbers.

rgds
kurtie

You can add an extra column in which you can display how many matches drawing X+1 has in relates to drawing X.

In your example:
2/01/2010 2 4 8 11 37 39
6/01/2010 1 5 8 19 24 29 1
there would be an extra column with the number '1' (1 number repeats).

Is this what you're looking for?

If you look to 06/01/2010 - 1 & 8 together

16 draws later 7/03/2010 - 1 & 8 again in the draw

At the moment im trying another systeem, need to play only 8 numbers, 2 times in a week , it gives me allready 1 times 4 balls and 5 balls in 42 draws ( 2draws in a week.
To play the 8 numbers its a cost of 14€/draw , when i have 3 numbers of the 6 i win 10*2.5€ = 25€

but i play only on paper here to check my system..

Hi kurtie
Here are a Excel formula which I use to see the repeating numbers.
My lotto is in columns A to I and I have put this formula in columns K to P.

=IF(OR(C5=$C4,C5=$D4,C5=$E4,C5=$F4,C5=$G4,C5=$H4), C5,"")
=IF(OR(D5=$C4,D5=$D4,D5=$E4,D5=$F4,D5=$G4,D5=$H4), D5,"")
=IF(OR(E5=$C4,E5=$D4,E5=$E4,E5=$F4,E5=$G4,E5=$H4), E5,"")
=IF(OR(F5=$C4,F5=$D4,F5=$E4,F5=$F4,F5=$G4,F5=$H4), F5,"")
=IF(OR(G5=$C4,G5=$D4,G5=$E4,G5=$F4,G5=$G4,G5=$H4), G5,"")
=IF(OR(H5=$C4,H5=$D4,H5=$E4,H5=$F4,H5=$G4,H5=$H4), H5,"")

Hope this will help you

BlouBul

hi ,

I will try this .

rgds,
kurtie

No need to track statistics ...
With combinatorics, you can find the exact repeat figures...
For lotto 6/42:

• 0 numbers : 37.13%
• 1 number : 43.12%
• 2 numbers : 16.84%
• 3 numbers : 2.72%
• 4 numbers : 0.18%
• 5 or 6 numbers : the rest

Good luck!
Stefan