View Single Post
 
Old 04-20-2016, 09:29 PM
xor xor is offline Windows 10 Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,101
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

If you have your numbers in A1:A100 then

Last value: =LOOKUP(2,1/(A1:A100<>""),A1:A100)

Address of last value: =ADDRESS(MATCH(9.9E+307,A:A),1,4)
Reply With Quote