|  

» Retrieving the Value of the First Nonblank Cell in a List

Problem:

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

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


Example:
Range1


X

Y
Z

Result X
Screenshot // Retrieving the Value of the First Nonblank Cell in a List
Retrieving the Value of the First Nonblank Cell in a List

Rate This Tip
12 34 5
Rating: 2.91     Views: 18905
No comments have been submitted.
Name
Comment Title
Comments