LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Easy Question

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
If - easy question mldancing Excel Discussion (Misc queries) 5 March 28th 07 01:26 PM
*EASY* question 2!! Laura \( '_' \) New Users to Excel 3 November 25th 05 02:01 PM
*EASY* question! Laura \( '_' \) New Users to Excel 3 November 25th 05 12:02 PM
new user with easy question? not easy for me speakeztruth New Users to Excel 5 June 3rd 05 09:40 PM
easy question .... i think Dean Excel Discussion (Misc queries) 1 January 6th 05 06:31 PM


All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"