double entry findings issue

I think could be better to avoid duplicates via DataValidation

eg. A = column of mails
select whole A column
Data - Data Validation
Allow = Custom
Formula: COUNTIF(A:A,A1)=1
Ok

it works if mails are manually entered so you can use both way against copy/paste