» Retrieving the Last Value in a Dynamic List
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
Problem: Column A contains a list of numbers that is being continually added to at its base.
We want to create a formula that will retrieve the last value in the column and automatically update when a new number is added.
Solution:
Use the OFFSET and COUNTA functions as shown in the following formula:
=OFFSET(A1,COUNTA($A:$A)-1,0)
Note:
The formula will only work correctly when there are no empty cells within the list.
Book Store:
Recommended Books:
- How to Read A Financial Report
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Microsoft Excel 2002 Simply Visual
- Financial Reporting and Analysis (2nd Edition)
- Special Edition Using Microsoft Outlook 2002
- Marketing Plans That Work, Targeting Growth and Profitability
No comments have been submitted.
