Hi All - I have a report that shows all job changes during a range of period; however, I just want only one line per person taking the most current row, and the previous title needs to be in column D like the example for "Smith" as indicated below. Could someone help me with this complex formula? Working with pivot table only give me count and I do not want that.
Thanks so much in advance for your assistance!
A B C D
Name Title Eff Date Previous Title
1 Smith Network Administrator 01/01/1999 "to be deleted"
2 Smith Accountant 04/01/2002 Network Administrator
3 Brown Accounts Payable Coordinator 01/01/1998
4 Brown Systems Administrator 10/01/1999
5 Brown Paralegal 05/01/2005
6 Williams Senior Acquisitions Analyst 12/01/2007
7 Jones Human Resources Administrator 09/15/2006
8 Jones Communication Director 11/23/2009
Bookmarks