I have a row of data that contains some blank spaces. I need to find the lower value of the 2 cells to the left that contain data (not blank cells).

eg:

Row 1 is populated thus:

8 blank 6 blank 4 blank 9

so the formula I need would give the answer as 6, because it is the lower of the 2 values closest to the left but not a blank cell.

Is this possible ?

Thank you.