Working with data in Excel

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
 
Z

Zone

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
 
Z

Zone

Mike, you can go ahead and e-mail me
(e-mail address removed), removing the nospam from the address. We'll
discuss.
James
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top