Welcome Guest
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
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 1 0 1 2 3 4 5 6 7 8 9 0 43 354 90 16 7 9 33 68 53 24 1 177 133 26 22 1 55 65 76 134 78 2 15 27 137 153 61 12 36 20 81 101 3 6 83 80 5 17 219 129 48 372 140 4 8 384 60 47 201 159 86 58 2 105 5 42 75 116 92 96 427 10 13 51 56 6 45 34 11 127 85 74 37 329 38 66 7 108 21 14 356 31 69 148 170 49 72 8 52 39 19 4 338 50 88 30 3 191 9 67 0 106 79 57 192 73 71 274 102

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

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.

 Page 1 of 1