How to find duplicates per email

[Coolavin]

Hello,

I have an CandidateEmail field and an ExamCode field  and I need to know which CandidateEmail have duplicate ExamCodes. 

There are several different types of ExamCodes and each CandidateEmail  shouldn't have more than one of any type. 

Would I use a SubStringCount or a COUNT TOTAL?

Thank you for your help.

[stevejoyce]

I think this would be your set analysis, aggregation depends on how you want to display....

Concat(Distinct {<CandidateEmail = {"=Count(Distinct ExamCode) > 1"} >} CandidateEmail , ', ')

[Coolavin]

Is there a way to get a count of how many duplicates each email has?