finding last number in column

R

Russ

I've got a column of numbers that's height changes everytime I add
more data. I would like to find the difference between the top number
and the bottom number and have that result in a cell above that
column. How can I write a formula that will adjust to the changing
location of the bottom number?


Russ
 
B

Bernard Liengme

The returns the last value in column A: =OFFSET(A1,COUNTA(A:A)-1,0) with the
proviso that there are no empty cells before the last data entry

Best wishes
 
G

Gord Dibben

Russ

=LOOKUP(9.99999999999999E+307,F:F) will fetch the last value in F.

It will ignore blanks in the column.

Gord Dibben Excel MVP
 
R

Russ

Thanks for the help. I'll try them both!

Russ

Russ

=LOOKUP(9.99999999999999E+307,F:F) will fetch the last value in F.

It will ignore blanks in the column.

Gord Dibben Excel MVP
Click to expand...
 
Top