» Retrieving the Last Value in a Dynamic List
CATEGORY - Lookup Formulas
VERSION - All Microsoft Excel Versions
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:
- Essentials of Investments with Standard & Poor's Educational Version of Market Insight + PowerWeb + Stock Trak Coupon
- Fish! A Remarkable Way to Boost Morale and Improve Results
- H&R Block's Just Plain Smart(tm) Tax Planning Advisor: A year-round approach to lowering your taxes this year, next year and beyond
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
- The Laws of Money, The Lessons of Life: Keep What You Have and Create What You Deserve
No comments have been submitted.

