Use the only the last value in a column in a formula

D

Dale V

How do I use only the last value in a column of numbers to add in a formula
elsewhere? For instance if I have a long column and add a new number to that
column each week, I only want to use the last added number in my formula
located elsewhere on the worksheet.
 
P

Peo Sjoblom

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

with the numbers in column A

--
Regards,

Peo Sjoblom

Portland, Oregon
 
M

Max

Dale V said:
... It works great even though I don't quite understand it.
Click to expand...

Try Bob Phillips' excellent page on the subject at:
http://www.xldynamic.com/source/xld.LastValue.html

The formula which Peo gave can be found under part:
#002 - Searching For Largest Possible Number Using LOOKUP

How it works and the associated constraints are also covered, amongst other
details.

Look through the entire white paper, it's really a fine piece of
craftsmanship there ..
 
D

Dale V

Thanks Max. I have a good understanding now how it works. I was even able
to make a few modifications for my application and it works fine. Thanks for
the websites.
 
Top