Quote:
Originally Posted by xor
Thank you, but I still don't understand.
Please take a look at the attached and give complete details as to how you come to 3, 2 and 1 in N2:P2.
I see one instance of 3 consecutive days under 90% and 1 instance of 4 consecutive days under 90%.
|
OK here we go.
Consecutive 2days in a row=count of 3
How... B2+c2=1;i2+j2=1;k2+l2=1, thus giving the answer 3
Consecutive 3days in a row =count of 2
How...B2+c2+d2=1;i2+j2+k2=1, thus giving the answer 2
Consecutive 4days in a row=count of 1
How...I2+j2+k2+l2=1, thus giving the answer 1.
Hope that helps. Sorry for late reply. Worked late.
Regards