Excel - formula last data cell

  • Thread starter Thread starter John S
  • Start date Start date
J

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
 
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
 
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
 
Back
Top