Find records with duplicate Codes

[Coolavin]

Hello,

I have two fields, email and ExamCode.

I need to find the emails that have duplicate ExamCodes

For example:
Email#1 has ExamCodes:
116C
316C
316C

Email#2 has ExamCodes:
116C
117C
110C
316C

I would need something that would only display Email#1 with the ExamCode that is a duplicate.
It should not display Email#2 

I tried something like this:
Count(TOTAL<Email> ExamCode) >= 2

But it ends up including ones that just have single ExamCodes. I am not sure what I am doing wrong. 

[Saravanan_Desingh]

Try this,

tab1:
LOAD * INLINE [
    Email#1 has ExamCodes:
    116C
    315C
    316C
];

tab2:
LOAD * INLINE [
    Email#2 has ExamCodes:
    116C
    117C
    110C
    316C
];

[Coolavin]

I don't have access to load. I need to know how to do this in an expression. 

[Saravanan_Desingh]

Dim: [Email#1 has ExamCodes:]

Exp: Only({<[Email#1 has ExamCodes:]=p([Email#2 has ExamCodes:])>}[Email#1 has ExamCodes:])

[Coolavin]

Email#1 and Email#2 should not be compared to each other. the emails need to be compared only within themselves. 

if an email has a duplicate ExamCode then it should show up. if an email has unique ExamCodes then it should NOT show up.