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