8 Replies Latest reply on Jun 22, 2017 6:37 AM by philmodjunk

    Find unique records based on one field

    g4guitar

      I have a list of contacts where some share the same email address. I know how to hide duplicate records based on a field using ! but this is not quite what I want because it doesn't discriminate. In other words I want to hide only the duplicate not the original so if I had 2 records with the email address test@gmail.com I still want one of them to appear while hiding the other. I guess what I am looking for is a find that finds all unique records based on a field. I want to put this into a script.

       

      Any help appreciated.