automatically select last value in a column
 

Hi,

Does anyone have an equation that will select the last value in a column?
I have the following that works to use the last value in a row of data:

=(INDEX('Portfolio Profit
Tracker'!B2:IV2,1,MATCH(9.99999999999999E+307,'Por tfolio Profit
Tracker'!B2:IV2,1))-B2)/B2

I have tried replacing the column values B2:IV2 with row values G13:G113,
but that does not work.

Thanks in advance!

Jon

Hi
see:
http://www.xldynamic.com/source/xld.LastValue.html

--
Regards
Frank Kabel
Frankfurt, Germany

Jon Horvath wrote:
Hi,

Does anyone have an equation that will select the last value in a
column? I have the following that works to use the last value in a
row of data:

=(INDEX('Portfolio Profit
Tracker'!B2:IV2,1,MATCH(9.99999999999999E+307,'Por tfolio Profit
Tracker'!B2:IV2,1))-B2)/B2

I have tried replacing the column values B2:IV2 with row values
G13:G113, but that does not work.

Thanks in advance!

Jon

A shorter version...

=(LOOKUP(9.99999999999999E+307,B2:IV2)-B2)/B2

And...

=(LOOKUP(9.99999999999999E+307,G13:G113)

will give you the last numerical value from G13:G113.

"Jon Horvath" wrote in message
...
Hi,

Does anyone have an equation that will select the last value in a
column?
I have the following that works to use the last value in a row of data:

=(INDEX('Portfolio Profit
Tracker'!B2:IV2,1,MATCH(9.99999999999999E+307,'Por tfolio Profit
Tracker'!B2:IV2,1))-B2)/B2

I have tried replacing the column values B2:IV2 with row values
G13:G113,
but that does not work.

Thanks in advance!

Jon