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.

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" wrote:

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.

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.

"Mike H" wrote:

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" wrote:

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.

Little shorter:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"surreygraham" wrote in message
...
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.

"Mike H" wrote:

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" wrote:

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.