Hi I want to display/list all contacts (Duplicates) who have the same first user name and last user name in my standard report, how can I do this? Do I have to use a formula field for this ?

Ex:- There are three records with same user first name and last name

  1. John White
  2. John White
  3. John White

So I want to list these three records.


Yes , Better go for formula field where you do all the logic checking if FN and LN is equal then populate it true , then show only that records in the report.

  • I actually dont mean first name = last name. Apologies if my question is confusing. I made edits to the question above. So what I want to display in my report are the contact records who have the same name. Would your solution still work on the criteria ?
    – Tinkerbell
    Aug 8 '17 at 15:27
  • Hi , In that case you need not work on any additional fields , you can still create a summary report and group by the contact First name(or) Last name which can give you a clue on it. The system will do case insensitive grouping
    – freaker87
    Aug 8 '17 at 16:22

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.