How to find largest sequence of a given number in excel? -
i have column of zeros , ones
1 0 0 0 1 1
i want find out largest sequence of zeros have in column , how many times appears.
with data in column a, in b1 enter:
=if(a1=1,0,1)
and in b2 enter:
=if(a2=0,1+b1,0)
and copy down:
the longest sequence is:
=max(b:b)
and number of times occurs is:
=countif(b:b,d1)
if max() formula in d1
Comments
Post a Comment