Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 03-19-2006, 03:51 AM
Novice
 
Join Date: Mar 2006
Posts: 3
paulrm906
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.

Thankyou

Paul Maynard
Moscow.
Reply With Quote
  #2  
Old 12-05-2008, 07:51 PM
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
Reply

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.
MSOfficeForums.com is not affiliated with Microsoft