swisscheez
08-18-2005, 04:49 PM
i'm working on creating a "report" using data imported in to excel and need some assistance from this group if at all possible.
what I want to be able to do is summarize something like this ...
DATEMARKETASSOCIATEJOB TITLEJOB STATUS CREDIT PRODUCTION
Jan-05STATESMITH, JANEBDOITN $ 5,000.00
Jan-05STATEDOE, JOHNCMACT $ 1,000.00
Jan-05STATEEXAMPLE, A.CMACT $ 2,000.00
Jan-05STATEJONES, BCMACT $ 4,500.00
Feb-05STATESMITH, JANECMACT $ 7,500.00
Feb-05STATEDOE, JOHNCMITN $ 9,000.00
Feb-05STATEEXAMPLE, A.CMITN $ 10,000.00
Feb-05STATEJONES, BCMITN $ 4,000.00
Mar-05STATESMITH, JANECMITN $ 3,500.00
Mar-05STATEDOE, JOHNBDOITN $ 3,200.00
Mar-05STATEEXAMPLE, A.CMACT $ 6,540.00
Mar-05STATEJONES, BCMACT $ 6,548.00
and I can do this just fine except for one thing.
Using Jane Smith as an example, you can see that her job title changes over time. I want to be able to sum all of Jane Smith's ytd data and grab her last or most recent job code. I'm just not how to do that last part. It probably is very easy but i'm just not getting it.
Thank you for you time.
Lance
what I want to be able to do is summarize something like this ...
DATEMARKETASSOCIATEJOB TITLEJOB STATUS CREDIT PRODUCTION
Jan-05STATESMITH, JANEBDOITN $ 5,000.00
Jan-05STATEDOE, JOHNCMACT $ 1,000.00
Jan-05STATEEXAMPLE, A.CMACT $ 2,000.00
Jan-05STATEJONES, BCMACT $ 4,500.00
Feb-05STATESMITH, JANECMACT $ 7,500.00
Feb-05STATEDOE, JOHNCMITN $ 9,000.00
Feb-05STATEEXAMPLE, A.CMITN $ 10,000.00
Feb-05STATEJONES, BCMITN $ 4,000.00
Mar-05STATESMITH, JANECMITN $ 3,500.00
Mar-05STATEDOE, JOHNBDOITN $ 3,200.00
Mar-05STATEEXAMPLE, A.CMACT $ 6,540.00
Mar-05STATEJONES, BCMACT $ 6,548.00
and I can do this just fine except for one thing.
Using Jane Smith as an example, you can see that her job title changes over time. I want to be able to sum all of Jane Smith's ytd data and grab her last or most recent job code. I'm just not how to do that last part. It probably is very easy but i'm just not getting it.
Thank you for you time.
Lance