Hello Excellers,

I hope you are doing EXCELlent ,

Ever since the “Conflict” in Ukraine I have been tracking the price of gas (petrol) as a project that I am interested in. And once you see the data you can imagine so many scenarios. OK enough lets talk about Excel.

In the image below I have the price per gallon of gas in Column A. The  Green means the price went down from the prior day, Yellow means no change in price from the prior day, and Red means the price increased from the prior day. The Dates are in Column F off the image.

What I would like to do is count the days it took to recover all the increases. For example on Row 899 the price increased. So the Target Price will be 3.088 (Row 898) Then on Row 903 the price started decreasing and we see that on Row 906 the price recovered to an equal amount (Row 900). And then on Row 909 the price is now <= to Target Price. 3.079 < 3.088 (Target Price) so all of the increases have been eliminated and now we are back to the last lowest price (and some more).

What Formula can I use to count the days it took the price to become <= the Target Price (3.088)

Thanks in Advance!

GiGi

​Hello Excellers, I hope you are doing EXCELlent , Ever since the “Conflict” in Ukraine I have been tracking the price of gas (petrol) as a project that I am interested in. And once you see the data you can imagine so many scenarios. OK enough lets talk about Excel. In the image below I have the price per gallon of gas in Column A. The  Green means the price went down from the prior day, Yellow means no change in price from the prior day, and Red means the price increased from the prior day. The Dates are in Column F off the image. What I would like to do is count the days it took to recover all the increases. For example on Row 899 the price increased. So the Target Price will be 3.088 (Row 898) Then on Row 903 the price started decreasing and we see that on Row 906 the price recovered to an equal amount (Row 900). And then on Row 909 the price is now <= to Target Price. 3.079 < 3.088 (Target Price) so all of the increases have been eliminated and now we are back to the last lowest price (and some more). What Formula can I use to count the days it took the price to become <= the Target Price (3.088) Thanks in Advance!GiGi  Read More

​