LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 43
Default earlest date not complete

I got a number of cell the first has the date the second has a number of
entry's in it, being completed, ss, inv, tl, and mgr, what I need is a way to
get the oldest date that do not have completed, so is there any way to get
the answer for this, it is to produce some thing like,

a b c
4/1/07 completed oldest date not completed 30/1/07
5/2/07 completed
6/2/07 tl
3/3/07 ss
30/1/07 tl

any ideas
thanks




 
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
Keep complete date series on X axis Jeff Eckermann Charts and Charting in Excel 2 July 13th 06 01:19 PM
same date and set up on complete workbook ED New Users to Excel 3 April 17th 06 04:22 PM
Percent Complete? bassec Excel Discussion (Misc queries) 1 March 28th 06 08:11 AM
Auto complete Peter Excel Discussion (Misc queries) 6 August 31st 05 02:20 PM
Auto complete? MNicholas New Users to Excel 3 August 21st 05 10:28 AM


All times are GMT +1. The time now is 07:29 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"