» 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:
- Keys to Reading an Annual Report (Barron's Business Keys)
- Accounting and Financial Fundamentals for Nonfinancial Executives
- A Mathematician Plays the Stock Market
- The McGraw-Hill Guide to Writing a High-Impact Business Plan: A Proven Blueprint for First-Time Entrepreneurs
- The Essential 55: An Award-Winning Educator's Rules for Discovering the Successful Student in Every Child
- The New Financial Order: Risk in the Twenty-First Century
No comments have been submitted.
