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 email@example.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.