How do I retreive the last # in a column?
 

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

How do I retreive the last # in a column?
 

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

How do I retreive the last # in a column?
 

Hi,

You can also try this

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

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com

"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