Excel - formula last data cell
 

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

Excel - formula last data cell
 

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
---------------
Jacob Skaria


"John S" wrote:

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

Excel - formula last data cell
 

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

"John S" wrote:

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