| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
| Column widths to adjust automatically? | Excel Discussion (Misc queries) | |||
| Copying the contents of a column into a chart | Excel Worksheet Functions | |||
| getting data from 2 excel sheets automatically | Excel Worksheet Functions | |||
| How to calculate the data in excel 2002 including only the last 9. | Excel Worksheet Functions | |||
Threaded Mode
