Last Cell

P

PeterLai

Hi,

I want to put the value of cell A1 = the last cell of column A

A2 in Column A of my worksheet is blank and I have to add entries in column
A .

I just want to show the last entry in cell A1.
What formula should I put in cell A1
 
P

Peo Sjoblom

One way

=INDEX(A2:A1000,MAX((A2:A1000<>"")*ROW(INDIRECT("2:1000")))-1)

entered with ctrl + shift & enter

extend the range if you believe you need more rows
 
F

Frank Kabel

Hi
if you don't have blank rows in between you may use the following
formula
=OFFSET($A$2,COUNTA($A$2:$A$10000)-1,0)
 
P

PeterLai

Thank you very much for your advice.

I have one more simple problem

How can I modify the formula if Cell A1 is on different sheet

I've tried to modify the formula as

=offset(sheet1!$A$2,counta(sheet1!$A:$A$1000)-1,0)

but it cannot work.
 
Top