Sample.xlsx

I used your formula on all the data I have and it pointed out that it doesn't account for the jump of F back to 0 transition. Sorry, I should have mentioned that.

Is there anyway you can take another look?

I've attached a data sample if you can think of anything else. Everything in this sheet should pass the logic. As you can see, the last two examples fail.

Thanks.