Working with data in Excel
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 |
Working with data in Excel
Mike, this looks like the kind of thing I have experience with.
Unfortunately, because of the newsgroup word wrap the info looks like gibberish. And the problem is rather complex. Could take some time to work through. If you want to explore further, post back and we'll work out something. James "mikebres" wrote in message ... 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 |
Working with data in Excel
Zone, thank you. Yes I would like to explore this further. What do you
recomend? "Zone" wrote: Mike, this looks like the kind of thing I have experience with. Unfortunately, because of the newsgroup word wrap the info looks like gibberish. And the problem is rather complex. Could take some time to work through. If you want to explore further, post back and we'll work out something. James "mikebres" wrote in message ... 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 |
Working with data in Excel
|
All times are GMT +1. The time now is 08:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com