I would suggest using conditional formatting to highlight duplicates in the column.
Formula: copy to clipboard
=COUNTIF(B:B,B2)>1

Not exactly what you are looking for, but it will avoid them being not noticed.