is there any way to restrict data entry in a cell to "unique values" only
E EZ Money Jul 11, 2003 #2 Select A1:A10 and Data>Validation>Allw>Custom and enter: =COUNTIF($A$1:$A$10,A1)=1 and you'll see how it works.
Select A1:A10 and Data>Validation>Allw>Custom and enter: =COUNTIF($A$1:$A$10,A1)=1 and you'll see how it works.
