Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
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

 
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
Data Base mmcstech Excel Discussion (Misc queries) 2 April 25th 07 08:46 PM
update a Pivot Table with new data added to the base data Graham Y Excel Discussion (Misc queries) 1 March 19th 07 02:12 PM
data base puiuluipui Excel Discussion (Misc queries) 4 November 2nd 06 12:26 PM
how do I print data in a spreadsheet data base to a mailing lable. Kevin Jamieson Excel Discussion (Misc queries) 0 March 15th 05 10:57 PM
how do I print data in a spreadsheet data base to a mailing lable. Database Excel Discussion (Misc queries) 0 March 15th 05 10:57 PM


All times are GMT +1. The time now is 09:34 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"