Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Last Number in a Column How to spread column in Word Gagilence Word 1 10-15-2008 09:19 AM
Last Number in a Column Making sure the correct number of characters are entered. leroytrolley Excel 1 07-25-2008 06:38 AM
No page number on appendix please davidaexp1 Word 0 08-22-2006 06:19 PM
Last Number in a Column Enter Number on any sheet one time only. paulrm906 Excel 1 04-28-2006 07:35 AM
Different page number formatting. gerrie Word 0 04-15-2006 07:31 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 06:39 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft