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.
The formula to get the last value
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.