I will see what I can do about that. It will have to be a formula that I send to you because the workbook becomes too large to be able to be sent. I had to trim it down to the bare bones just to get it uploaded. There is much checking that I have to do yet.

The Previous Service Data is going to be difficult to check because so little of it matches.

One thing that you should take a look at is the Number and Number 1 columns. In a lot of cases, these values are matched pairs in that where a record has one of them, the other value is also there. This is duplication that will over time really slow down the processing of your data.

I will work on your workbook and get back to you. This could be a long process....but I hope not.