M
mikebres
I searching for a method as well as a specific way to get information from a
table of data. Here is a small subset of the data:
# ID Tag Mach F Cause Fail Type Site ID Site Name Sort Plan Run
Start Date Time Event Date Time Delta Hours Event Day
53 J18CUSA048N080100000037T 72 1 LOC 802000000 Denver
P&DC 143F7802 7/31/2007 18:02 7/31/2007 18:05 0 Tue
53 J18CUSA048N080100000037T 121 1 LOC 601000000 Carol Stream
P&DC 463F7GLA 8/2/2007 16:16 8/2/2007 17:31 47 Thu
53 J18CUSA048N080100000037T 2346 3 LOC 802000000 Denver
P&DC 146F7020 8/5/2007 23:50 8/5/2007 23:55 78 Sun
53 J18CUSA048N080100000037T 2068 2 LOC 802000000 Denver
P&DC 144F7800 8/6/2007 3:08 8/6/2007 4:08 4 Mon
54 J18CUSA048N080101200230T 95 2 LOC 802000000 Denver
P&DC 141F7802 7/31/2007 23:10 7/31/2007 23:21 0 Tue
54 J18CUSA048N080101200230T 162 2 LOC 802000000 Denver
P&DC 143F7802 8/4/2007 21:46 8/4/2007 21:50 94 Sat
54 J18CUSA048N080101200230T 2068 1 LOC 802000000 Denver
P&DC 144F7800 8/8/2007 2:58 8/8/2007 6:17 80 Wed
What I would like to be able to do is select a group of the data based on
the ID Tag. Then working within this group to pull certain pieces of
information. For example I would want to get the first and last Event Date
Time for each ID Tag, the First and Last Site name along with the name of the
site where the piece was at the wrong site (Carol Stream P&DC).
Eventually I would like to be able to select whatever I need from this data.
Right now I am using VBA and walking through the table and using IF Then
getting the bit of data I need whenever the ID Tag changes. This is starting
to get cumbersome as I try to get different bits of data from the table.
Then I'm writing the result to another worksheet as a summary.
I realize a database would probably be the way to go, but we only have Excel
to use consistently across the company. So I need to find a way to do this
in Excel.
More than anything I'm hoping someone has a better method to do this.
Thanks
Mike
table of data. Here is a small subset of the data:
# ID Tag Mach F Cause Fail Type Site ID Site Name Sort Plan Run
Start Date Time Event Date Time Delta Hours Event Day
53 J18CUSA048N080100000037T 72 1 LOC 802000000 Denver
P&DC 143F7802 7/31/2007 18:02 7/31/2007 18:05 0 Tue
53 J18CUSA048N080100000037T 121 1 LOC 601000000 Carol Stream
P&DC 463F7GLA 8/2/2007 16:16 8/2/2007 17:31 47 Thu
53 J18CUSA048N080100000037T 2346 3 LOC 802000000 Denver
P&DC 146F7020 8/5/2007 23:50 8/5/2007 23:55 78 Sun
53 J18CUSA048N080100000037T 2068 2 LOC 802000000 Denver
P&DC 144F7800 8/6/2007 3:08 8/6/2007 4:08 4 Mon
54 J18CUSA048N080101200230T 95 2 LOC 802000000 Denver
P&DC 141F7802 7/31/2007 23:10 7/31/2007 23:21 0 Tue
54 J18CUSA048N080101200230T 162 2 LOC 802000000 Denver
P&DC 143F7802 8/4/2007 21:46 8/4/2007 21:50 94 Sat
54 J18CUSA048N080101200230T 2068 1 LOC 802000000 Denver
P&DC 144F7800 8/8/2007 2:58 8/8/2007 6:17 80 Wed
What I would like to be able to do is select a group of the data based on
the ID Tag. Then working within this group to pull certain pieces of
information. For example I would want to get the first and last Event Date
Time for each ID Tag, the First and Last Site name along with the name of the
site where the piece was at the wrong site (Carol Stream P&DC).
Eventually I would like to be able to select whatever I need from this data.
Right now I am using VBA and walking through the table and using IF Then
getting the bit of data I need whenever the ID Tag changes. This is starting
to get cumbersome as I try to get different bits of data from the table.
Then I'm writing the result to another worksheet as a summary.
I realize a database would probably be the way to go, but we only have Excel
to use consistently across the company. So I need to find a way to do this
in Excel.
More than anything I'm hoping someone has a better method to do this.
Thanks
Mike