Welcome Guest
Log In | Register )
You last visited December 8, 2016, 2:47 am
All times shown are
Eastern Time (GMT-5:00)

Excel Formula for Counting Skips

Topic closed. 2 replies. Last post 11 years ago by CARBOB.

Page 1 of 1
PrintE-mailLink
CARBOB's avatar - FL LOTTERY_LOGO.png
ORLANDO, FLORIDA
United States
Member #4924
June 3, 2004
5896 Posts
Offline
Posted: January 28, 2006, 7:02 pm - IP Logged

This formula will count the skips between digits. "B" col is pos 1 ; "H" col is going down; "I" col, going across.

Carbob

Confirmed with Shift+Ctrl+Enter 

=MATCH(TRUE,($B$11:$B$953=$H37)*($B$12:$B$954=I$36)>0,0)-1 

POS 10123456789
04335490167933685324
11771332622155657613478
215271371536112362081101
36838051721912948372140
48384604720115986582105
54275116929642710135156
64534111278574373293866
7108211435631691481704972
852391943385088303191
967010679571927371274102

    lottaloot's avatar - AvatarZ56
    Redford/MI
    United States
    Member #3396
    January 18, 2004
    4867 Posts
    Offline
    Posted: January 28, 2006, 7:07 pm - IP Logged

    Thanks for the post!

     

    Is this for Florida????

    L ttaL   T

      CARBOB's avatar - FL LOTTERY_LOGO.png
      ORLANDO, FLORIDA
      United States
      Member #4924
      June 3, 2004
      5896 Posts
      Offline
      Posted: January 28, 2006, 8:15 pm - IP Logged

      Thanks for the post!

       

      Is this for Florida????

      No KIm, it's Play4 TSMD. Some of those numbers, I would have never expected. I will add this to my workbook for Fla.. I can hardly wait to see some of those numbers.