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