For each row where the labor category and employee name is the same I need the earliest invoice date. For example I need to know the earliest date Jack Doe invoiced as Executive Accountant I by having that row highlighted. The the earliest date Jack Doe invoiced as a Acct Executive by highlighting that row. I have a thousands of line items to deal with so figuring this out will save a lot of time.
<colgroup><col><col><col></colgroup><tbody>
</tbody>
Invoice Date | Labor Category | Employee Name |
11/20/2012 | Executive Accountant I | Doe, Jack |
12/20/2012 | Executive Accountant I | Doe, Jack |
2/26/2014 | Acct. Executive | Doe, Jack |
2/26/2014 | Acct. Executive | Doe, Jack |
4/22/2014 | Acct. Executive | Doe, Jack |
8/22/2013 | Executive Accountant II | Doe, Jack |
9/24/2013 | Executive Accountant II | Doe, Jack |
10/24/2013 | Executive Accountant II | Doe, Jack |
4/30/2014 | Account Executive II | Doe, Jack |
6/24/2014 | Account Executive II | Doe, Jack |
10/27/2014 | Account Executive II | Doe, Jack |
10/6/2014 | Senior Executive | Doe, Jack |
10/8/2014 | Senior Executive | Doe, Jack |
12/1/2014 | Executive Accountant II | Doe, Jack |
3/28/2016 | Senior Executive | Doe, Jack |
4/21/2016 | Senior Executive | Doe, Jack |
5/31/2016 | Senior Executive | Doe, Jack |
2/24/2015 | Sr. Acct. Supervisor | Smith, Jane |
2/10/2015 | Account Supervisor | Smith, Jane |
2/24/2015 | Account Supervisor | Smith, Jane |
3/25/2015 | Account Supervisor | Smith, Jane |
<colgroup><col><col><col></colgroup><tbody>
</tbody>