CODEWITHSUNDEEP
excel
YaZ
YaZ

Reputation: 43

Excel - i need first non-blank value of a column

This is my Column. I need the 2.46 in cell b1 how do i do that?

A1 ---- BLANK
A2 ---- BLANK
A3 ---- BLANK
A4 ---- 2.46
A5 ---- BLANK
A6 ---- BLANK
A7 ---- BLANK
A8 ---- BLANK
A9 ---- 2.58
A10 ---- BLANK
A11 ---- BLANK
A12 ---- BLANK

Upvotes: 0

Views: 42

Answers (1)

barry houdini
barry houdini

Reputation: 46401

Try this formula

=INDEX(B1:B100,MATCH(TRUE,INDEX(B1:B100<>"",0),0))

extend ranges as required

Upvotes: 3

Related Questions