» Retrieving the Value of the First Nonblank Cell in a List
CATEGORY - Excel Formula and Function
VERSION - All Microsoft Excel Versions
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
Book Store:
Recommended Books:
No comments have been submitted.
Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
