Hi All, newbie here. I was perusing your excellent site looking for an answer to a problem I have. I have two columns (K & L) with over 5000 rows with data. I'm interested in finding the longest string of zeros. (then afterwards adding extra criteria (Column E with either "H" or "A" in it & Column I with "League") I'm stumped at the minute even without adding the criteria. However I came across this thread on here
www.mrexcel.com
and I think its very similar to what I need, though its a column, not a row and I'm only interested in zeros.
Many thanks.

Finding longest sequence of the same value in a row
Hi all, Hope someone can please help with this as I've spent hours scratching my head. :) I'm looking for a formula that calculates the green values in the J column (which I've added in manually). I need the formula to please find the longest streak in the row of consecutive instances of the...
and I think its very similar to what I need, though its a column, not a row and I'm only interested in zeros.
Many thanks.