Get the value from the last cell in a column?

Hello, yesterday i was working on my current excelproject and got stuck as I in some way have to get the value of the last cell in a constantly growing(manual input which generates this column) column. Of course I could just copy + paste the value but I'd rather have som function doing it for me.

Anyone got ideas on how to do this?

Thanks in advance!

Very much thanks for the quick and good answer! I'll try to post in right group next time, sry