Hi

Select the column with product names, and goto Data Validation Allow:
Custom Formula: =CountIf($A:$A,A1)=1

Hopes this helps
...
Per



"Ed Green" <Ed skrev i meddelelsen
...
I am entering product names in excel (in the hundreds) and I would like to
have excel check that as I enter a name it has not already been used.