A day counter that resets itself

[Helnik17]

Hello!

There is value in a cell that shows a percentage - Lets say A1 = 5%.

I want to enter a formula that starts counting the number of days when cell A1 changes to a value greater than 10%.

Let's say on day 8, Cell A1= 9%, the counter should reset back to 0 days.


Thanks and I really appreciate the help. First time posting on this wonderful forum!

 

[Ezguy4u]

Helnik Welcome to the forum. It's been my experience that more problems will get solutions if the person uses that XL2BB software and posts input data and output data. Now reviewing your problem, one of the items I have to wonder about is why on day 8 cell A1 isn't greater than 10%, yet you want reset. Does that mean every 8 days you want to reset? So, the limit to my ignorance is unlimited, and somebody may come up with a formula to accomplish your problem. But for sure, a VBA program would work. Would you be open to a program? Let us know.