finding last number in column

  • Thread starter Thread starter Russ
  • Start date Start date
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
 
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
 
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
 
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...
 
Back
Top