Right now I have a report that pulls a lot of changes to someone's work record. So, when they change job titles. I'm interested in the Entry date - the date when the employee actually went into the job title. Also, I'm only interested in a select range of job titles. I've attached an excel.
Basically I want to know the *earliest* entry date a person has for the specific job title I'm interested in. For example, on the attached report, for Jimmy Jones (rows 2 - 5). I'm interested in the *earliest* entry date that Jimmy had that title. On the report, he's got Ops Officer 2 for both rows 2 and 3 - both have different 'codes' (I'm interested in both codes, BUT they reflect the same job). Since they both reflect the same job, I'm only interested in the earliest Op Officer 2 (row 3, entry date 7/5/14).
Right now, I figure, a count if to tell me which rows have codes I'm interested in. I'd delete the other ones. This isn't very efficient and also doesn't account for the Jimmy double job problem.
Anyone have any suggestions?
Bookmarks