Go to last cell in column

I

ingalla

Can any one tell me how to use a function to find the last cell in a column
with a value in it?

Thanks in advance

Andy
 
R

RaymundCG

Hi Ingalla!

Supposing your data is in column A, you may try to use the ff formula (e.g.
to be entered in cell B1)

=INDEX(A:A,COUNTA(A:A),1)

Please note that this formula does not work if the data in the column is
non-contiguous (has empty cells in between).

Hope this helps
 
C

CLR

And, if you want the ADDRESS of that cell rather than the value therein, use
this....

=CELL("ADDRESS",INDEX(A:A,COUNTA(A:A),1))

Vaya con Dios,
Chuck, CABGx3
 
Top