Set a formula to always select the last value present in a colum
 

I have a colum of data that I update each day with yesterdays number (i.e I
add data below the previous day each day)

I want to set a formula to always grab the last day of data that I have
entered in this colum. The final cell in that colum that contains any data.

I want to do this so that it can populate a calculation on another sheet
showing how much a the total of this colum increased yesterday so that I can
calculate yesterdays contibution to the running total.

Thanks for your help.

Say you want the last value on Col B capptured use the following
=LOOKUP(99999999999999900000,B:B)

"bpiepgrass" wrote in message
...
I have a colum of data that I update each day with yesterdays number (i.e I
add data below the previous day each day)

I want to set a formula to always grab the last day of data that I have
entered in this colum. The final cell in that colum that contains any
data.

I want to do this so that it can populate a calculation on another sheet
showing how much a the total of this colum increased yesterday so that I
can
calculate yesterdays contibution to the running total.

Thanks for your help.

Excel's Help states that "Largest number allowed to be typed into a
cell" is: 9.99999999999999E+307, a recognizable value which fits the idiom:

=LOOKUP(9.99999999999999E+307,B:B)

N Harkawat wrote:
Say you want the last value on Col B capptured use the following
=LOOKUP(99999999999999900000,B:B)

"bpiepgrass" wrote in message
...

I have a colum of data that I update each day with yesterdays number (i.e I
add data below the previous day each day)

I want to set a formula to always grab the last day of data that I have
entered in this colum. The final cell in that colum that contains any
data.

I want to do this so that it can populate a calculation on another sheet
showing how much a the total of this colum increased yesterday so that I
can
calculate yesterdays contibution to the running total.

Thanks for your help.