How do I stop duplicate entries in excel database eg. company nam

J

JillyB

When creating a simple databse of company records from which to do mail shots
is there a feature that will stop the entry of duplicate company name for
example please.

Thanks
 
S

ShaneDevenshire

Hi,

Excel supports this also. Suppose your data is in A1:A10 then select the
range and choose Data, Validation, Custom
enter the following in the Formula box
=COUNTIF($A$1:$A$10,A1)<2

If this helps, please click Yes.
 

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 do I eliminate duplicae records in excel file 1
get Data Validation to stop, list supplied, duplicate data entries 1
Import data from excel 1
Outlook 2016 Add-in that creates an html signature doesn't embed images(logos). How can I do this ? 0
Automation of scanned file storage based on content 0
Finding Duplicates 4
Finding Duplicate Cell Entries 6
Removing duplicate records with long names in Excel 2007 2

Top