Microsoft Office Forums Last Number in a Column

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-19-2006, 03:51 AM
paulrm906 paulrm906 is offline
Novice
Last Number in a Column
 
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
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
Reply

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 03:37 PM.


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