» 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:
- Getting to Yes: Negotiating Agreement Without Giving In
- Windows XP for Dummies
- Analyzing Markets, Products, and Marketing Plans
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- Microsoft Windows XP Registry Guide
- Microsoft Access 2002 for Dummies
No comments have been submitted.
