» 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:
- Microsoft Excel 2002 Simply Visual
- Lower Your Taxes - Big Time! : Wealth-Building, Tax Reduction Secrets from an IRS Insider
- Mastering Excel 2000 (for beginner)
- The 22 Immutable Laws of Branding
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The Analysis and Use of Financial Statements
No comments have been submitted.
