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

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

How do I stop duplicate entries in excel database eg. companynam
 

Access databases support this.

JillyB wrote:

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

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

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.
--
Thanks,
Shane Devenshire


"JillyB" wrote:

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