» 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:
- Fish! A Remarkable Way to Boost Morale and Improve Results
- Microsoft Office Xp: Advanced Concepts and Techniques: Word 2002, Excel 2002, Access 2002, Powerpoint 2002
- Mortgages For Dummies®
- The Total Money Makeover. : A Proven Plan for Financial Fitness
- Definitive Guide to Excel VBA
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
No comments have been submitted.
