How do I retreive the last # in a column?

[Claudio]

I am trying to substract the value in the first cell in a column from the
last value in that column using a function, which i can't find.

I want this unknown function to find the last cell with a value in a column
, Not a blank cell, and then substract the first cell from it, it will
probably go like this:

=lastvalue(A:A)-A1

 

[T. Valko]

like this:

=lastvalue(A:A)-A1

Try this:

=LOOKUP(1E100,A:A)-A1

 

[Ashish Mathur]

Hi,

You can also try this

=LOOKUP(99^99,A:A)-A1

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com