Hi
Try:

Use Data Validation--Settings--Allow: Custom--Formula:
=COUNTIF($C$1:$C1,C1)=1


"repeat" wrote:

I have social security numbers in a column. I cannot have a repeat of any of
these numbers. Is there a way to set it up so it alerts me if I have two of
the same social security numbers in that column?