Last Number in a Column

		Microsoft Office Forums > Microsoft Excel > Excel
Last Number in a Column

FAQ

Thread Tools

Display Modes

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 !!!

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to spread column in Word	Gagilence	Word	1	10-15-2008 09:19 AM
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
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 01:01 AM.