» 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:
- Microsoft Word Version 2002 Inside Out
- Advanced modelling in finance using Excel and VBA
- The Guide to Understanding Financial Statements
- Windows XP Pocket Reference
- Financial Statement Analysis with S&P insert card
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
No comments have been submitted.
