mizetreestump
New Member
- Joined
- Sep 12, 2013
- Messages
- 1
My new position at work has me doing a lot of spreadsheet analysis. I love it, but realize I have to ramp up big time to learn how to do a bunch of excel how-to functions. I have a 15 year background of writing Visual Basic EXE applications, and told I can use a lot of that experience via VBA with Excel, but not yet familiar with that. This week I have a task that sounds simple, but I can't figure it out:
I have two spreadsheet pages. Each has rows that contain (among other things) a serial number column and a date column. I need to: Find all occurences where any serial number from sheet A appears in sheet B, AND, where the DATE on sheet A is more recent than sheet B for that serial number entry. One caveat is that the Serial Numbers : both sheet A and B could have the same Serial Number on it's own sheet listed more than once with a different date.
I have thousands of entries on both sheets so trying to do this manually is out of the question. I got so far as to figure out how to find which serial numbers appear on both spreadsheets, but that's it. I just started to learn Pivots, but don't see any easy way to do this with Pivot tables either.
If I can't figure it out or get a reply here, I'll end up dumping the data into flat files, and writing a short Visual Basic EXE application that reads both files in, but in this new position at work, I am going to have to ramp up and learn most of the limits of excel data compares, how to do "if" and "thens" to whatever degree is possible, before resorting to manual external programming each time I need to do an analysis. Also - any good training references on things like this if you have any are welcomed.
I have two spreadsheet pages. Each has rows that contain (among other things) a serial number column and a date column. I need to: Find all occurences where any serial number from sheet A appears in sheet B, AND, where the DATE on sheet A is more recent than sheet B for that serial number entry. One caveat is that the Serial Numbers : both sheet A and B could have the same Serial Number on it's own sheet listed more than once with a different date.
I have thousands of entries on both sheets so trying to do this manually is out of the question. I got so far as to figure out how to find which serial numbers appear on both spreadsheets, but that's it. I just started to learn Pivots, but don't see any easy way to do this with Pivot tables either.
If I can't figure it out or get a reply here, I'll end up dumping the data into flat files, and writing a short Visual Basic EXE application that reads both files in, but in this new position at work, I am going to have to ramp up and learn most of the limits of excel data compares, how to do "if" and "thens" to whatever degree is possible, before resorting to manual external programming each time I need to do an analysis. Also - any good training references on things like this if you have any are welcomed.
