MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Ensure all cells in a column contain unique values...


Posted by Katherine on December 08, 2001 12:24 PM

Is there formatting or a formula that would not allow you to enter any values that are already present within a given column?


Posted by Aladin Akyurek on December 08, 2001 12:55 PM

Katherine --

Lets say that you want to do input control on column A.
Activate the range of interest from A2 on where values must be entered;
Activate Data|Validation;
Choose Custom for Allow;
Enter as formula:

=COUNTIF($A$1:A1,A2)=0

Click OK.

A1 may either contain a label or be empty.

Aladin

=========

Posted by Katherine on December 08, 2001 6:29 PM

That works great - thank you SO much!