The final objective is to reference the last populated (higher row number) cell from a column (its value).

I found a function that returns the row number of the last populated (higher row number) cell from a column. In the picture, the function returns '8'. If we keep adding numbers to the column, the number will naturally increase.

I tried to use that function so that a cell (A2) always displays the value of the last populated cell from a column.

The closest I've come is


but that returns 'F8' (see A4), not the value of 'F8'.

Is there any way to do this?

enter image description here


The formula you are looking for is:




Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.