Formula to return value of last cell in column

[ChrisA]

Is there a formula that will return the value of the last non empty cell of a column?

 

[Yogi Anand]

On 2002-11-05 00:16, ChrisA wrote:
Is there a formula that will return the value of the last non empty cell of a column?

Hi ChrisA:

I am going to assume the values are all in numeric and the column is A ...

=INDEX(A:A,MATCH(9.99999999999999E+307,A:A))

Regards!
Yogi Anand

 

[ChrisA]

Wonderful

Thank You!

 

[Derek]

This message was edited by Derek on 2002-11-05 01:04