| 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) | |||
Linear Mode
