Duplicate data in same field
I use a calculation to extract the company name from an email address. Sometimes I end up with duplicates in the 'company' field (eg firstname.lastname@example.org and email@example.com with give me xyz in two company fields). I want to set up a field that will flag up these duplicates as I want to manually choose with record(s) to delete.
Anyone have a code I can use?