Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Base | Excel Discussion (Misc queries) | |||
update a Pivot Table with new data added to the base data | Excel Discussion (Misc queries) | |||
data base | Excel Discussion (Misc queries) | |||
how do I print data in a spreadsheet data base to a mailing lable. | Excel Discussion (Misc queries) | |||
how do I print data in a spreadsheet data base to a mailing lable. | Excel Discussion (Misc queries) |