» 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:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Office XP Introductory Concepts and Techniques
- Cashflow Quadrant: Rich Dad's Guide to Financial Freedom
- The Guide to Understanding Financial Statements
- Managerial Accounting: Tools for Business Decision Making, WebCT, 2nd Edition
- Windows XP for Dummies
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?
