View Single Post
  #1   Report Post  
Jon Horvath
 
Posts: n/a
Default 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