It can be Use to identify Duplicates..
=COUNTIF($A$1:A1,A1)