| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I always insert last cell from a increasing array ?
In a increasing array of values I want to use always the last value as input
in another formula. Is there a smart trick? Thanks |
|
#2
|
|||
|
|||
|
How do I always insert last cell from a increasing array ?
=INDEX(A:A,MATCH(9.99999999999999E307,A:A))
will get the last value in column A. -- HTH RP (remove nothere from the email address if mailing direct) "Radu" wrote in message ... In a increasing array of values I want to use always the last value as input in another formula. Is there a smart trick? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using single cell reference as table array argument in Vlookup | Excel Worksheet Functions | |||
| referencing the value of a cell containing an array formula | Excel Worksheet Functions | |||
| cell color index comparison | New Users to Excel | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Insert value of a cell as a filename | Excel Worksheet Functions | |||
Linear Mode
