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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

copy paste value 1
nightmare formula 4
Last data in colum 3
If Formula Help 4
Vlookup Fixed reference but move on colums Ref# 3
the If Statements 2
Project a date and calculate a % in one formula 4
matrix math in excel? 2

Back
Top