» Get the value 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:A4, the following values appear
Enter the following formula in cell B1: =OFFSET(A1,COUNTA(A:A)-1,0)
The result: DDD
Book Store:
Recommended Books:
- Adventure Capitalist: The Ultimate Road Trip
- The 22 Immutable Laws of Branding
- The Sweet Potato Queens' Big-Ass Cookbook and Financial Planner
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- Microsoft Windows XP Step by Step (With CD-ROM)
- Microsoft Excel 2002 Formulas (With CD-ROM)
No comments have been submitted.
