=IF(COUNTIF($A$1:$A$100,A1)1,"Dup","Not Dup")

copy down


--

Regards,

Peo Sjoblom

"TotallyConfused" wrote in
message ...
Can someone please help with this this formula? I am trying to comparing
if
there are dupes in a column. (=IF(A2=A1,1,0)). Any help will be greatly
appreciated. thank you.