Number last time out

Reply #2

Tialuvslotto — Fri, 01 Apr 2016 11:13:24 GMT

You want to calculate a skip table.

Start your table in row 6 (in my example) and column K and fill every number in your lottery (48/49?) in the subsequent columns.

Then, paste the following formula in cell K8 (i.e. leave a blank row below the table header row 6)

=IF(OR($F8=K$6,$G8=K$6,$H8=K$6,$I8=K$6,$J8=K$6),0,K7+1)

Copy across and then copy the row down.

This will give the current skip for each number: 0=last hit, 1=out 1 draw, 2=out 2 draws, etc.

Reply #1

n1legin — Fri, 01 Apr 2016 10:44:28 GMT

Hi

What i use is this formula for the 1st time out

=SMALL(IF($D$2:$H$33=N4,ROW($D$2:$H$33)),ROW($1:$1))

2nd time out

=SMALL(IF($D$2:$H$33=N4,ROW($D$2:$H$33)),ROW($2:$2))

3rd time out

=SMALL(IF($D$2:$H$33=N4,ROW($D$2:$H$33)),ROW($3:$3))

Etc .............

$D$2:$H$33 = data area

N4 = Number to check last out

$1:$1 = 1st time out

$2:$2 = 2nd time out

$3:$3 = 3rd time out

Hope this helps

Number last time out

n1legin — Wed, 16 Mar 2016 15:58:18 GMT

Hello to everyone, I'm trying to work out how to find out the 2nd, 3rd, 4th ..... last time a number was drawn ie.

1 - 10 - 25 - 33 - 48

2 - 4 - 6 - 30 - 50

7 - 11 - 15 - 33 - 45

25 - 37 - 42 - 41 - 48

number 2 was last out 1 draw ago

number 33 was last out 2 draws ago

number 48 was last out 3 draws ago etc.........

My draw numbers are in 5 columns f2,j2 and are hoping to check the last 150 draws

thanks in advance