Finding last value in a column

[BadgerWI]

Dear Folks,

I'm attempting to setup a chart that tracks a value that
changes monthly, (CPI). Each month I add a row to the
column with the latest value.

How do I write a formula that will identify the last
value in a column so that I can do calculations on the
month to month change, annual change, etc..

thanks

Using Excel 2003

 

[Frank Kabel]

Hi
if this is a numeric value try:
=LOOKUP(9.99999999E307,A:A)

 

[BadgerWI]

Thanks,
Question #2, is there a function that will return the row # of that value?

 

[Frank Kabel]

Hi
if you only have numeric values try:
=MATCH(9.99999999E307,A:A)

 

[BadgerWI]

That's a bit inelegant, but it works !

Even adjusts when I add a new row !

thanks