» 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:
thank you for providing a screenshot
roomi
Thank you very much for providing a screen shot. It helped me understand very promptly exactly what is the use of this formula and how does it actually works.
thanks again.
In Reverse
Is it possible to retrieve the value of the LAST Nonblank cell in a list?
