Note:

I did my tests on values <75. Just change the the reference to 75 in the
formula with whatever your set point value might be.

Biff

"Biff" wrote in message
...
Hi!

Here's one way:

Requires 2 helper columns.

Assume your data is in the range A1:A20000.

Insert a new row 1.

In B1 enter 1.

Enter this formula in B2 and copy down to B20001:

=IF(A2<75,"",1)

In B20002 enter 1.

Enter this formula in C2 and copy down to C20002:

=IF(B2<"",COUNTBLANK(INDEX($B$1:B1,MATCH(2,$B$1:B 1)):B2),"")

Now, to count the number of times there are 60 consecutive rows with
values <75:

=COUNTIF(C:C,60)

Biff

"Fifi" wrote in message
...

I have a col of numbers and need to find if the number in any row
(dis-regarding 0) is less than a set point say 250 for for the next 60
consecutive rows. So, if I have col of 20,000 numbers how do I find
that there are no 60 consecutive rows whose values are lesser than 250.
Any help will be appreciated.


--
Fifi
------------------------------------------------------------------------
Fifi's Profile:
http://www.excelforum.com/member.php...o&userid=12325
View this thread:
http://www.excelforum.com/showthread...hreadid=511219