Excel - formula last data cell

[John S]

I am looking for a way to create a formula that will access the last cell
with data in a column or row.

I a have a spreadsheet and the information where the last data is changes as
i update or copy in new data. I want a formula that will always give me the
results of the last cell in a column that contains a value.

Thanks for your help

 

[Jacob Skaria]

The below will work for Col A. Adjust to suit
=LOOKUP(2,1/(Sheet1!A1:A65535<>""),Sheet1!A1:A65535)

If this post helps click Yes

 

[Mike H]

Hi,

last value in row 1
=LOOKUP(2,1/(1:1<>""),1:1)

Last value in column A
=LOOKUP(2,1/(A:A<>""),A:A)

Mike