Determine if a Value is Duplicated in a Column
To determine if a value is duplicated in a column you can use
=COUNTIF(A:A,B1)>1
Will display TRUE if the value in cell B1 appears more than once in column A and FALSE if it appears once or not at all.
You can use the above as a logical test in an IF function as well.