Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate company name to be deleted | Excel Discussion (Misc queries) | |||
NO DUPLICATE ENTRIES IN A COLUMN USING EXCEL | Setting up and Configuration of Excel | |||
How do I delete duplicate entries in excel? | New Users to Excel | |||
How do I set up an Excel column to not allow duplicate entries (m. | Excel Discussion (Misc queries) | |||
Duplicate entries in an excel list? | Excel Discussion (Misc queries) |