Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Thread Tools Display Modes
Old 03-19-2006, 03:51 AM
paulrm906 paulrm906 is offline
Last Number in a Column
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
Emily Emily is offline
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
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 09:44 PM.

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