| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Base
First Excel is not a database, it's a spreadsheet. When you choose to use a
spreadsheet over a database you are trading away a lot of functionality. But, moving on to your problem... Is there only 1 Open entry and 1 ASG entry per series in the spreadsheet? "orquidea" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Base
Yes, every series will have just one entry per stage in the process
Thanks, Orquidea "Lance" wrote: First Excel is not a database, it's a spreadsheet. When you choose to use a spreadsheet over a database you are trading away a lot of functionality. But, moving on to your problem... Is there only 1 Open entry and 1 ASG entry per series in the spreadsheet? "orquidea" wrote: 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Base
OK.. maybe a cheap and easy approach could work.
Is there ALWAYS an entry in each stage for each series? "orquidea" wrote: Yes, every series will have just one entry per stage in the process Thanks, Orquidea "Lance" wrote: First Excel is not a database, it's a spreadsheet. When you choose to use a spreadsheet over a database you are trading away a lot of functionality. But, moving on to your problem... Is there only 1 Open entry and 1 ASG entry per series in the spreadsheet? "orquidea" wrote: 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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Base
No, so some stages on some series will be black
"Lance" wrote: OK.. maybe a cheap and easy approach could work. Is there ALWAYS an entry in each stage for each series? "orquidea" wrote: Yes, every series will have just one entry per stage in the process Thanks, Orquidea "Lance" wrote: First Excel is not a database, it's a spreadsheet. When you choose to use a spreadsheet over a database you are trading away a lot of functionality. But, moving on to your problem... Is there only 1 Open entry and 1 ASG entry per series in the spreadsheet? "orquidea" wrote: 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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data Base
Are you familiar with the vlookup function?
"orquidea" wrote: No, so some stages on some series will be black "Lance" wrote: OK.. maybe a cheap and easy approach could work. Is there ALWAYS an entry in each stage for each series? "orquidea" wrote: Yes, every series will have just one entry per stage in the process Thanks, Orquidea "Lance" wrote: First Excel is not a database, it's a spreadsheet. When you choose to use a spreadsheet over a database you are trading away a lot of functionality. But, moving on to your problem... Is there only 1 Open entry and 1 ASG entry per series in the spreadsheet? "orquidea" wrote: 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 |
| Reply |
| 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) | |||
Hybrid Mode
