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:

enter image description here

the longest sequence is:

=max(b:b)

and number of times occurs is:

=countif(b:b,d1)

if max() formula in d1

Script