Tip Printed from ExcelTip.com

---

Retrieving the Value of the First Non-Blank Cell in a List


Problem:

Retrieving the value of the first non-blank cell in Range1 (cells A2:A7).

Solution:
Use the INDEX and MATCH functions as shown in the following Array formula:
{=INDEX(A2:A7,MATCH(TRUE,A2:A7<>"",0))}

To apply Array formula:
Select the cell, press and simultaneously press .