Hello andy! Your answer is he
http://www.ozgrid.com/forum/showthread.php?t=71645

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"andy" wrote:

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!