Hi Ninja,
"I do not understand why the first set of counts is highlighted in green, while the next set of counts is highlighted in red. Can you explain?"
Explanation: For example, let say a technician see the car machine KL123 which have 5 consecutive times of pressure every week, that need to be settled, then green color has highlighted for 5 consecutive times after the date of 1/10/2019 completion with successfully. The next 5 consecutive times of pressure, if the technician have not completed the task, then highlighted it in red color such as to give them an alert. The countif will be 1 every time there is a 5 consecutive times, which is yet to complete.
"
What we are doing with the counts is to increment the previous count by 1 if the present reading is equal to or above the threshold ; since the first cell does not actually have a previous count , either we have a different formula for the first cell , or we use the cell to the left of it as the previous count ; we have to ensure that this cell does not have any data."
Question : Still blur blur, is there any examples based from my workbook?
"In the data , the data relating to pressure is in every 4th column ; when we are using helper columns , these are in consecutive columns ; thus to take the pressure reading from every 4th column , we use the multiplier of 3 ; this will give us column offsets of 0 , 3 , 6 , 9 , 12 ,... ; if you see , the pressure readings are in columns C , F , I , L , O ,... which correspond to the above offsets."
Explanation: Great explanation, Ninja. I understand.
Let me know again, if you still need to further explain.
Thanks.