Because on the last date entered so far Jan 14, the value is 21. So if I start looking back, on the previous date, Jan 13, the value is 9, so this is less that 21. Then on Jan 12 the value is 13, also less than 21. But... on Jan 11, the value was 26, which is greater than 21, so I want to capture this 21 value in cell E5, along with the date Jan 11 in cell G5.



As I enter more dates and values for each date, I want excel to compare the current score value in cloumn B, with the previous cells, and work its way up to where it finds a value greater than the current value in column B. Hope that makes sense