automatically select last value in a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,'Portfolio 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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Change formulas in a column based on a selection. 3
Comparison of columns using Conditional Formatting 3
Sumproduct in matrix means 3
Changing part of cell reference in INDEX - MATCH formula 7
With F1 value, look at A, if match or partial match return B 5
Dependent drop down dynamic range formula, off sheet. 7
Variable Cell Reference 2

Back
Top