I need 2 formulas. The Digits in Col's B:F, range from 1-36, In Col G, I would like a formula that will return a Y(Yes) or N(No). Y if any of the digits are consective, N if none. In Col H, I would like a formula that will count the number of Consectives. Ex if B:F has 25,26, return a 2; 25,26,27, return a 3. Can this be done. All suggestions appreciated.
Thanks!!!
Thanks!!!
EL FANTASY 5 REPEATS.xlsm | |||||||||
---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | |||
3 | 22 | 27 | 28 | 33 | 36 | Y | 2 | ||
4 | 06 | 12 | 18 | 19 | 20 | Y | 3 | ||
5 | 02 | 13 | 16 | 18 | 26 | N | 0 | ||
6 | 19 | 24 | 31 | 32 | 33 | ||||
7 | 07 | 11 | 21 | 26 | 35 | ||||
IMPORTED FILES |