Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 03-19-2006, 03:51 AM
Join Date: Mar 2006
Posts: 3
Default Last Number in a Column

Hello everyone

I am currently using the formula =LOOKUP(9.99999999999999E+307,A:A) to find the last number in a colmn (The above formula was thanks from Aladin) But unfortuneately it will not work if there are formulas in the column. does anyone know how to solve this problem as I really do need to keep this formula in that column.


Paul Maynard
Reply With Quote
Old 12-05-2008, 07:51 PM
Join Date: Dec 2008
Location: Hong Kong
Posts: 7
Emily is on a distinguished road

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

Thread Tools
Display Modes

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

All times are GMT -7. The time now is 07:57 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft