Problem: Find last input value in a column

 

Solution: =INDIRECT("A" & (COUNTA(A:A)))

Functions:
INDIRECT(ref_text;[a1])
Returns the reference specified by a text string

COUNTA(value1;[value2];...)
Counts the number of cells in a range that are not empty

Related posts:

Excel: Percentage of total number

excel find weekday in period

Excel: Dynamically sum a column

Excel: Count cells

Excel: Automatically create a numbered list