Need help on a formula that will return the next lesser value in column F that is less than the value of row 17 (45.81) (i.e. 44.81). The formula needs to look back in column F in cells above the current value to find the next value that is less than and skip the blank cells. Can anyone help, this one has me stumped.
ScreenHunter_15 Jun. 04 13.21.jpg
Bookmarks