My data starting at column a1 to ??
How do I count consecutive zero's in rows and exclude blanks? (2 or more zeroes)
SR 12, 12, 11, 0, 0, 0, 12, 11, 7, 0, 1, 10, 0, 0, 13, 0, 45, 11, 17, 0, 23, 7, 9, 0, 0 = 3
PP 12, 1, 10, 12, 11, 7, 0, 0, 1, 10, 0, 0, 13, 0, 45, 11, 17, 0, 23, 7, 9, 0, 0 = 3
Bookmarks