now all i have to do is make it work for upto 50000 entries but thanks for
the start

"Max" wrote:

Oops, think a slight tweak is needed to the formula :
In E1: =IF(D1="","",IF(SUM(D1:$D$14)$G$2,"Yes",""))

Change it to:
In E1: =IF(D1="","",IF(SUM(OFFSET(D1,,,3))$G$2,"Yes","") )
then copy E1 down as before

Corrected sample at:
http://cjoint.com/?doiUXGBq2b
Monitoring Consecutive Limit Breaches_Revised.xls
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---