» 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:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Excel 2002 Simply Visual
- Positioning: The Battle for Your Mind
- Who Moved My Cheese? An Amazing Way to Deal with Change in Your Work and in Your Life
- Microsoft Word Version 2002 Inside Out
- Preparing the Marketing Plan (Ama Marketing Toolbox Series New Edition)
No comments have been submitted.
