torsdag den 8. august 2013

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:

Hope you find this tip useful.

Ingen kommentarer:

Send en kommentar