Welcome Guest
You last visited January 21, 2017, 2:27 pm
All times shown are
Eastern Time (GMT-5:00)

# Number last time out

Topic closed. 2 replies. Last post 10 months ago by Tialuvslotto.

 Page 1 of 1
New Member

United Kingdom
Member #173704
March 14, 2016
2 Posts
Offline
 Posted: March 16, 2016, 11:58 am - IP Logged

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

New Member

United Kingdom
Member #173704
March 14, 2016
2 Posts
Offline
 Posted: April 1, 2016, 6:44 am - IP Logged

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

Texas
United States
Member #150797
December 31, 2013
822 Posts
Offline
 Posted: April 1, 2016, 7:13 am - IP Logged

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.

"There is no such thing as luck; only adequate or inadequate preparation to cope with a statistical universe."

~Robert A. Heinlein

 Page 1 of 1