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

[Guest]

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.

 

[Peo Sjoblom]

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

with the numbers in column A

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Guest]

Thank you Peo. It works great even though I don't quite understand it.

 

[Max]

... It works great even though I don't quite understand it.

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

---

 

[Guest]

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.

 

[Max]

You're welcome, Dale !
Thanks for feeding back ..