Many ways to skin that cat:

=IF(COUNTIF(A:A,A1)>1,"Duplicate","")
in column B and drag down.

abousetta