Does anyone know how to search for the last higher value from a list? for
example,
[A1] 100
[A2] 75
[A3] 60
[A4] 50
[A5] 40
[A6] 30
[A7] 20
[A8] 45, which is the last value from the lists, and return 50 on cell B8,
since
45 is higher than 20,30,40, until 45 is less than 50, therefore, the result
is less than 50. Does anyone know how to code it in excel?
Thank you in advance
Eric