Hi all, I am trying to calculate for my lotto number with number of skips for each drawing,
example like below
D1 D2 D3 D4 D5 D6
3 5 10 23 48 52
4 8 11 48 52 55
8 9 10 25 34 40 54
example:
number 8 hit and hit again on next drawing, the skip is 0, number 10 hit again at the first draw, then hit again on 3rd draw, the skip is 2
Is there any macro or formula i could use?
thanks
Bookmarks