Return the last value in a column

In this Excel tutorial you will teach yourself how to create a formula which returns the last value in a column.

This tutorial is useful when you have a column of data and sometimes you add some data there. In this case you can easy to return the last value to some cell you want.

To return the last value from the last cell in the A column just use this Excel formula: =INDEX(A:A;MATCH(MAX(A:A);A:A;1))

Return the last value in a column

This is an array formula so to execute it you should use this keyboard keys: CTRL + SHIFT + ENTER.

Tip: This formula also works when you have some empty cells in the column.