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
|