like this:
=lastvalue(A:A)-A1

Try this:

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

--
Biff
Microsoft Excel MVP


"Claudio" wrote in message
...
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