Good Morning
I am new to this forum and wish to have some help with an issue! Please see sample spreadsheet as attached. I had issues uploading the actual spreadsheet. Cell G1 is a value to be entered manually. When the value in column B is greater than the value in cell G1 for the first time, I want the corresponding value in column C to be returned in cell G2. In this example, I have entered the value '100' in cell G1. The first time the value in column B goes above 100 is on 23/02/2020 and therefore the corresponding value to be returned is 16.
Dates are always in order (oldest first) and the data could go to row 5000. Values in row B are not always in order. The attached image is just a sample.
Can anyone help with the formula that needs to be entered in cell G2? I have researched the forum with no luck. I am using Excel 365.
Many thanks
Bookmarks