LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
mag mag is offline
external usenet poster
 
Posts: 4
Default help with formula for last input in column


I would appreciate if someone can help me with this

In first column I will type date in some free format

1.01.2012.
3.01.2012
10.01.12.
11.01.11
blank
blank
blank
....

in one cell at the end of table I would like to have the formula that
will show me or will copy last input (date, string or cell value) in
column or defined range (for instance: A5:A35)

is it possible to use formula in one cell for this in Excel 2007

thanks in advance

DMag
 
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
inverse of the column function? i.e. input a number, output thecorresponding column text label Brotherharry Excel Worksheet Functions 19 February 14th 09 12:37 AM
INPUT BOX FIND NAME IN COLUMN A Donald E Excel Discussion (Misc queries) 0 September 29th 08 05:56 PM
Output in Column A based on Input in Column B SteveC Excel Worksheet Functions 10 January 4th 06 07:10 PM
input to 2nd column help stn0795 Excel Discussion (Misc queries) 1 June 8th 05 12:25 AM
Autofill Column D based on input in Column C Helen McClaine Excel Discussion (Misc queries) 1 April 5th 05 09:11 PM


All times are GMT +1. The time now is 01:30 PM.

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"