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

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

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

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

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

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

No too much but if you explain a litlle bit to me what should I do and with
the Excel help I think I would be able to do it.

Thanks for replying back

Orquidea

"Lance" wrote:

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

If I'm understanding your data layout correctly, it's:

A B C D
1 Series Time Series Time
2 Series Time Series Time
3 Series Time Series Time
4 Series Time Series Time

Which I do find kind of odd by the way..

So essentially you are going to make a new column (E) which will use the
vlookup function to search through column C until it finds a match for the
value in the current row of column A, and then return the value of D.

So the formula for E1 would be =VLOOKUP(A1,C:D,2,FALSE)

A1 - the cell with the search value
C:D - the cell range to look through, only the left most column will be
searched but we needed to include the D column so we could return a value
from it.
2 - the column number to return a value from ( D in this case )
False - the data is not sorted, so this must be false else an error is
returned

You will then have the correct time in column E to match the series in
column A. The display will be confusing as columns C & D will not match A, B
& C.. so you might want to have your data display in another worksheet.


"orquidea" wrote:

No too much but if you explain a litlle bit to me what should I do and with
the Excel help I think I would be able to do it.

Thanks for replying back

Orquidea

"Lance" wrote:

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

Thanks a lot Lance, It worked perfectly with all the data and I succed with
what I wanted to do.

Orquidea

"Lance" wrote:

If I'm understanding your data layout correctly, it's:

A B C D
1 Series Time Series Time
2 Series Time Series Time
3 Series Time Series Time
4 Series Time Series Time

Which I do find kind of odd by the way..

So essentially you are going to make a new column (E) which will use the
vlookup function to search through column C until it finds a match for the
value in the current row of column A, and then return the value of D.

So the formula for E1 would be =VLOOKUP(A1,C:D,2,FALSE)

A1 - the cell with the search value
C:D - the cell range to look through, only the left most column will be
searched but we needed to include the D column so we could return a value
from it.
2 - the column number to return a value from ( D in this case )
False - the data is not sorted, so this must be false else an error is
returned

You will then have the correct time in column E to match the series in
column A. The display will be confusing as columns C & D will not match A, B
& C.. so you might want to have your data display in another worksheet.


"orquidea" wrote:

No too much but if you explain a litlle bit to me what should I do and with
the Excel help I think I would be able to do it.

Thanks for replying back

Orquidea

"Lance" wrote:

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