Would like a function formula that counts the number a times a specific value appears consecutively in a specific column.
Ex. In column H62:H96, the values appear (vertically):
1, 1, 0, 1, 0, 1, 0, 0, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 0, 1, 0, 1, 0, 1, 0, 1, 1, 1, 1, 0, 0, 0, 0, 0, 0
I would like a formula i could drag across multiple columns that calculates the number of times the value '1' appears consecutively. However, i dont want it to count every time it appears consecutively, only the time it appears the most. For example, the above sequence would yield a value of 7 because the number 1 appeared 7 times in a row at its max.
Thank you!
Bookmarks