return first non blank value celli in a row

[magatic]

Hello! I have values calculated in a row with an if statement, so cells D33: H33 have values blank (formula returned), 1.70, 1.72, 1.87, 2. I need the formula to return first non blank cell, so in this case would be 1.70 & years.
Please advise. Thank you so much!

 

[Weazel]

maybe something like

=INDEX(D33:H33,MATCH(TRUE,D33:H33<>"",0)) control shift enter

 

[jasonb75]

Are the values always in ascending order?

=MIN(D3:H33)

 

[magatic]

Thank you for your response. The values are different, and the blank cell could be in a couple first cells, so I would like the formula to pick the first non-blank value.

It could be something like this...blank, blank, 0.95, 0.85, 5...The answer should be 0.95

Thank you.

 

[magatic]

Thank you very much. It worked.

 

[Aladin Akyurek]

Thank you for your response. The values are different, and the blank cell could be in a couple first cells, so I would like the formula to pick the first non-blank value.

It could be something like this...blank, blank, 0.95, 0.85, 5...The answer should be 0.95

Thank you.

See post #2.

If the data is numeric...

=INDEX(D33:H33,MATCH(TRUE,ISNUMBER(D33:H33),0))

confirmed with control+shift+enter, not just enter, would be more coherent.