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

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
--
Thanks and kind regards


"ingalla" wrote:

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

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





"RaymundCG" wrote:

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
--
Thanks and kind regards


"ingalla" wrote:

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