Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

how to count max string of successive zero's

i am analysing the seasonability of non-occurance (=0) . i have a table with 52 columns which represent the weeks of the year.

i would like to count the max string of successive zeros in a row to see how long there is no occurance.

how can i do this?