Greetings,

I've a list of over 100 thousand records with ID, name, code etc.

What I'm trying to identify is if a certain code i.e. H0004 appears along with any other codes for the same ID# as we do not allow the H0004 code to exist with any other codes for the same person.

In the attached file sheet1 is the sample list, and sheet2 is how I envision the result should look like.



TIA

Regards,

Attached Files

Sample.xlsx (13.6 KB, 13 views)