Are the numbers to count *really* 1s?

So, you want to find the longest streak of contiguous consecutive 1s?

--
Biff
Microsoft Excel MVP


"andy" wrote in message
...
Hi,
I would like to find a formula that will give me the largest consecutive
sting of numbers out of a list. Here is an example of the list
(A1:A10000):
this answer is 3.

A
1
1
blank
1
blank
1
1
1

Thanks!