how to automatically update a cell value?

  • Thread starter Thread starter Carter Johnson
  • Start date Start date
C

Carter Johnson

I have a data table in Excel as follows:

Month Percent
Jan 2%
Feb 7%
Mar 4%
Apr
May
Jun

I would like to have a separate cell (i.e. Cell X) that will
automatically update with the latest value from the data column. In the
above example, the Cell X value would be 4%, but if I add additional
data to the column, such as 9% in April, the Cell X value would show 9%.
How do I create a formula for this?
 
One way, in cell x put

=INDEX(B:B,MATCH(9.99999999999999E+307,B:B))

where column B holds the percentage, format x as percentage

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
One way:

Assume that the Percent label is in B1 and there are no blanks in the
middle of the list:

=INDEX(B:B,COUNTA(B:B))
 
Academic question this: Is this the equivalent of
=INDEX(B:B,MATCH(0,B:B,-1))
?
I don't fully understand how this works, am I right in that it always scans
from the bottom of the column upwards?

Pascal
 
Back
Top