» Get the Row number of the last non blank cell in a column in Microsoft Excel
CATEGORY - Other Q&A Formulas
VERSION - All Microsoft Excel Versions
In cells A1:A14, the following values appear
Enter the following formula in cell B1: =ROW(OFFSET(A1,COUNTA(A:A)-1,0))
The result: 14
Book Store:
Recommended Books:
- Now, Discover Your Strengths
- Excel Charts
- Real Estate Loopholes: Secrets of Successful Real Estate Investing
- Infectious Greed: How Deceit and Risk Corrupted the Financial Markets
- The Intelligent Investor: The Definitive Book On Value Investing, Revised Edition
- Business Analysis with Microsoft Excel (2nd Edition)
No comments have been submitted.
