» 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:
- Advanced modelling in finance using Excel and VBA
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
- The Interpretation of Financial Statements
- Not-for-Profit Accounting Made Easy
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
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?
