Welcome Guest
Log In | Register )
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
PrintE-mailLink
Avatar
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

thanks in advance

    Avatar
    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

      Tialuvslotto's avatar - Jailin
      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