» 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:
- VBA for Modelers: Developing Decision Support Systems Using Microsoft« Excel
- Marketing Plans That Work, Targeting Growth and Profitability
- Accounting for Dummies
- Your First Business Plan: A Simple Question and Answer Format Designed to Help You Write Your Own Plan (3rd Ed)
- Marketing Plan: A Handbook with Marketing Plan
- Windows XP All-in-One Desk Reference For Dummies
No comments have been submitted.
