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

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

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

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

with the numbers in column A

--
Regards,

Peo Sjoblom

Portland, Oregon




"Dale V" wrote in message
...
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.
--
Dale VanHoose

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

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


"Peo Sjoblom" wrote:

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

with the numbers in column A

--
Regards,

Peo Sjoblom

Portland, Oregon




"Dale V" wrote in message
...
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.
--
Dale VanHoose

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

"Dale V" wrote:
... 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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

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


"Max" wrote:

"Dale V" wrote:
... 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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

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

You're welcome, Dale !
Thanks for feeding back ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Dale V" wrote in message
...
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.
--
Dale VanHoose