How do I keep duplicate text from being entered in an excel file?

E

Ed Green

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

Per Jessen

Hi

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

Hopes this helps
...
Per
 
J

Jim Thomlinson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Import 4 Different Excel Files from One Folder 0
Ensure data entered where required - how, please? 3
Text searching in Excel? 3
identify duplicate data in excel spreadsheet 3
Hyperlinks changed by Excel again! 5
Excel Spreadsheet Manipulation 21
Can I check for duplicate content as I fill in a product name in e 1

Top