A shink wrote:
I am trying to locate the last value in a column and then the second to last,
then third to last and so on to be placed in a seperate section of my
spreadsheet.
I am using the following formula to locate the last cell which is:
Lookup(2,1/(A3:A145<"")),A3:A145)
Where do I go from here?
Thanks for the help
Last numeric value:
=LOOKUP(9.99999999999999E+307,A3:A145)
Second to the last numeric value:
=LOOKUP(9.99999999999999E+307,A3:INDEX(A3:A145,MAT CH(9.99999999999999E+307,A3:A145)-1))
If you meant to "locate" any value (last entry of any type), a different
type of formula is required.
|