If you work with chronological lists or daily updates, you might also track the last item in a constantly changing list of values. Fortunately, you can combine Excel’s INDEX() and COUNTA() functions to return the last value in a list by using the following expression:

=INDEX(column, COUNTA(column), 1)

For instance, to return the last value in column A, you’d use the expression


As you update the list, the formula automatically compensates.

The one thing this formula can’t handle is an empty cell. For instance, the formula for column B (cell G3) returns 0 when it encounters the empty cell (at cell C9).

However, if you enter 0, instead of leaving the cell blank, the formula returns the correct value, 0.073.