Wallyeye,

I want to combine the duplicate records as indicated in the example. All of the information in the cells match except for the Assignment End Date and Assignment Start date. Where this is the case, I would like to change the start date to the earliest of the two, and the end date to the later in the two entries.

Example.xlsx