last value in a column that is being added to

  • Thread starter Thread starter Ben
  • Start date Start date
B

Ben

Hi,

Could someone here tell me how I could grab the last value in a column that
is being added to (that is the columnm is being extended with more values).
I have column where I add a value every so often. I would like to
automatically display the last value I typed in the column in another cell
(actually in another sheet but that doesn't matter).

I hope I described this adequately.

Thanks for your help,
Ben


--
"What passes for wisdom may only be eloquent foolishness"

Cheap long distance calling using Onesuite (http://www.onesuite.com).
2.5 cents/min anywhere in the U.S., to Canada or the U.K. No monthly or
connection fees! Use promotional code 038664643 for 20 free minutes.
 
Assuming the column is column B and the column has a value in all rows
upto the last row, then =OFFSET(B2,COUNTA(B2:B65536)-1,0,1,1) will give
the contents of the last cell in the row.
 
Hi Ben
if you have no blank rows in between you may use:
=OFFSET($A$1,COUNTA($A:$A)-1,0)

if you have blank rows in between try
=OFFSET($A$1,MATCH(9.99999999E307,$A:$A)-1,0)
 
Back
Top