Thread: Data Base
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
orquidea orquidea is offline
external usenet poster
 
Posts: 132
Default Data Base

Hi All

I need to measure the performance of a service. I have to time how long it
takes for series 502 from OPEN to ASG. I wouldn't be a problem if I had the
data from the same series in the same row, but it is not the case. I will
have the OPN time in row 2 and the ASG time in row 3 or 4 or 5. The process
have 7 steps and not all the series go through all 7 steps. That means that
if I sorted all the series in ascendent order, the series not necessarily
match in the same row.

Is there any way I can sort the data so I get all the data of series 502
in the same row? Below is the example of the raw data.

A B C D

1 SERIE OPEN SERIE ASG
2 502 11/12/07 17:20 505 11/12/07 20:50
4 507 11/12/07 15:20 502 11/12/07 11:30
5