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.

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 (E-Mail Removed)> skrev i meddelelsen
news:509170E8-C641-435F-9DAC-(E-Mail Removed)...
>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.

You can use data validation with a custom formula. To restict the entries in
Column A

Select Column A
Select Data -> Validation | Custom
Add this formula
=COUNTIF(A:A, A1) = 1
Select Ok

Column A should now be restricted to unique entries.
--
HTH...

Jim Thomlinson


"Ed Green" wrote:

> 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.