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!
