| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Last Number in 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. -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=524023 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last Number in Column
For alternative formulae see:
http://www.xldynamic.com/source/xld....l#last_numeric -- Gary's Student "paulrm906" wrote: 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. -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=524023 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Last Number in Column
Thanks Gary's Student It works great and the link as many useful formulas also Thankyou Paul Maynard -- paulrm906 ------------------------------------------------------------------------ paulrm906's Profile: http://www.excelforum.com/member.php...o&userid=28776 View this thread: http://www.excelforum.com/showthread...hreadid=524023 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SEeing if a number in one column is in another column | Excel Discussion (Misc queries) | |||
| Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
| Running total w/2 columns - Excel | Excel Worksheet Functions | |||
| look up number in column | Excel Worksheet Functions | |||
| How do I sort a column a unique number? | Excel Worksheet Functions | |||
Linear Mode
