Thread
: [Solved]
Last Number in a Column
View Single Post
12-05-2008, 07:51 PM
Emily
Novice
Join Date: Dec 2008
Location: Hong Kong
Posts: 7
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 !!!
Emily
View Public Profile
Visit Emily's homepage!
Find all posts by Emily