Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
You're welcome, Bob - 1E100 is a bit easier to type than
9.99999999999999E+307 (Excel's largest number), and is usually large enough in most situations. Pete On Jul 14, 1:17 am, "Bob" wrote: Thank you. Bob "Pete_UK" wrote in message ups.com... Assuming your figures (numbers ?) are in column A, try this in B1: =LOOKUP(1E100,A:A) Hope this helps. Pete On Jul 14, 12:40 am, "Bob" wrote: Excel 2003 I think this is easy but I don't know how to do it. I have a column of figures that we keep adding to and it gets longer and longer. I just need a formula that will return the last figure in the column at any given time. Thanks in advance... Bob- Hide quoted text - - Show quoted text - |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
If - easy question | Excel Discussion (Misc queries) | |||
*EASY* question 2!! | New Users to Excel | |||
*EASY* question! | New Users to Excel | |||
new user with easy question? not easy for me | New Users to Excel | |||
easy question .... i think | Excel Discussion (Misc queries) |