Picking up last value in column in Excel

[surreygraham]

Every day I add a new row of data to a spreadsheet. At the foot of this
growing array of numbers are several rows of formulae which need to use the
latest data added to the column immediately above them in order to make a
computation. Currently I have to physically change these formulae every day
in order to accomplish this but I'm sure there must be a better way.

 

[Mike H]

Hi,

Maybe this.

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

The will take the last used numeric cell in column B and multiply it by 5 so

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

Returns the value of the last used cell in Col B that is numeric which you
can incorporate into a formula.

Mike

 

[surreygraham]

Thanks Mike. I used this solution, merely adapting the B:B to a specific
range in column B, and it worked perfectly. I'm not sure why it works, but
all that matters is that it works! Thanks once again. G.

 

[RagDyer]

Little shorter:

=LOOKUP(99^99,B:B)*5