» 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:
- The Complete Book of Business Plans: Simple Steps to Writing a Powerful Business Plan (Small Business Sourcebooks)
- Microsoft Word Version 2002 Step By Step (With CD-ROM)
- Analyzing Markets, Products, and Marketing Plans
- Understanding Financial Statements
- Now, Discover Your Strengths
- Final Accounting: Ambition, Greed and the Fall of Arthur Andersen
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?

