#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 !!! |
|
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 |