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
|