How to combine results based on duplicates and make a differentiation?

[rizwanulhasan]

Hi all,

Hope all are well.

Need a help in attached file.

Column A contains some numbers which are duplicated but has different country codes in column E. All these different codes belonging to same numbers in column A should be populated in column F separated by a comma.

Example: value in cell A2 (6291107439891) is repeated thrice and has KW,QA and AE in column E. Therefore result in cell F2 is KW,QA,AE.

Further, column F should be compared with column J and if any value in column F is not present in column J, the same should be highlighted in column K. For multiple miss, they should be populated by a comma.

Example: KW,QA,AE not present in column J. so result in cell K2 is KW,QA,AE.

In short, i want to know what country codes in column F are not present in column J.

If value in column J is #N/A, then result in column K should also be #N/A