Compare two cells with Text strings separated by comma; return Unique & Duplicate values

Hi,

I have vast data flowing from Primavera P6. There are numerous Activity IDs' that has to be compared between two schedules. Each cell has several text strings (Activity ID) that are separated by a comma (,). I have recreated the scenario in the below table and require 3 different results as in the table. A simple substitute function is able to produce accurate results. I did try some VBA's but the results were partial. I have attached the file with the same explanation and the Real sample data for understanding. I need some expert advice to help solving the problem.

Thanks in advance

Excel Querry.JPG