Thread: Status Changes
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CLR
 
Posts: n/a
Default Status Changes

Consider Data Filter AutoFilter......it will show you all the "a" dates,
or "b" dates, or show you all the "a,b,c,etc" on a given date, or date
range......

Vaya con Dios,
Chuck, CABGx3




"NL" wrote in message
...
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.