i need a formula to count how manny 0 are after each 1 and show the bigest value

[saintdevil8]

Hey guys, i'm stuck at this for 4 days. I need a formula to count how many 0's are after each 1, and then to show me the bigest value. Thanksexample.xlsx

[FDibbins]

In C3, copied down (and across) use this...
=IF(A3<>0,0,C2+1)

Then a simple =MAX(C3:C22) in C1 and D1 will give you what you need

[saintdevil8]

Thanks, it's good

[FDibbins]

Happy to help.

If this answers your question, please mark this thread solved using the thread tools just above your 1st post