Thread: [Solved] Last Number in a Column
View Single Post
 
Old 12-05-2008, 07:51 PM
Emily Emily is offline
Novice
 
Join Date: Dec 2008
Location: Hong Kong
Posts: 7
Emily is on a distinguished road
Default

Use Array formula

=INDEX($A$1:$A$65536,LARGE(IF($A$1:$A$65536<>"",RO W($A$1:$A$65536)),1),1)

**** Entered with Ctrl+Shift+enter rather than just enter !!!
Reply With Quote