Display last number in a column

[JOGIER]

I have a column that is updated on a regular basis and I want the last entry to be displayed in a specific cell.

Thank you.

[sglife]

I think no one response because no one could understand what you need.
How about give us some more details

[Paul]

Hi Jogier,

As long as there are no blanks in your column, you could use this formula to get the last cell value in the column (formula assumes your list is in column A, starting in A1):

=OFFSET($A$1,COUNTA(A:A)-1,0)

If you have blanks, or for alternatives, take a look at: http://www.mrexcel.com/archive/Formulas/12938.html

[JOGIER]

Sorry for any confusion I may have caused. The link provided got me to the solution to my question.

Thank you all.

Jim O