LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NL
 
Posts: n/a
Default Status Changes

I am trying to use one Status field married with a changing date field to
show a progression through the process any possble formulaes that might help.

Start Date 31/12/04

Status Change Date
a 01/01/05
b 01/02/05
c 01/03/05
d 01/04/05
e 01/05/05

The data collected will use a days calculation to work out average times in
process.

I just didnt want to have five collumns of visible data if not neccessary.

Thanks for all or any help.


 
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
Does anyone have a good Status Report template for excel? Dave Excel Discussion (Misc queries) 0 March 17th 06 12:36 AM
List "OPEN" orders based on a status column beechum1 Excel Worksheet Functions 2 February 13th 06 12:12 PM
TEXT STATUS -VS- Numbers DDBeards Charts and Charting in Excel 1 August 15th 05 01:48 AM
returning a sheet to blank orginal status? Mile029 Excel Discussion (Misc queries) 2 July 13th 05 08:28 PM
Display No. of Rows in Status Bar Marty Excel Discussion (Misc queries) 2 January 24th 05 10:29 PM


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