Microsoft Excel and unique column values (unique constraint)

How do you make sure your column values are unique when you enter a new value into a column.
Like the unique constraint for sql databases.

Excel 2010
Choose your column, Data > Data Validation > Data Validation > Custom.
For Column A use this formula:
=COUNTIF($A:$A;A1)<2

Hope you find this tip useful.