AnsweredAssumed Answered

Find unique records based on one field

Question asked by g4guitar on Mar 20, 2017
Latest reply on Jun 22, 2017 by philmodjunk

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.

Outcomes