| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep duplicate text from being entered in an excel file?
I am entering product names in excel (in the hundreds) and I would like to
have excel check that as I enter a name it has not already been used. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep duplicate text from being entered in an excel file?
Hi
Select the column with product names, and goto Data Validation Allow: Custom Formula: =CountIf($A:$A,A1)=1 Hopes this helps ... Per "Ed Green" <Ed skrev i meddelelsen ... I am entering product names in excel (in the hundreds) and I would like to have excel check that as I enter a name it has not already been used. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How do I keep duplicate text from being entered in an excel file?
You can use data validation with a custom formula. To restict the entries in
Column A Select Column A Select Data - Validation | Custom Add this formula =COUNTIF(A:A, A1) = 1 Select Ok Column A should now be restricted to unique entries. -- HTH... Jim Thomlinson "Ed Green" wrote: I am entering product names in excel (in the hundreds) and I would like to have excel check that as I enter a name it has not already been used. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Prevent duplicate data from being entered into the same column | Excel Worksheet Functions | |||
| Duplicate the contents of a row when text is entered in a cell | Excel Discussion (Misc queries) | |||
| How Excel can tell me i have entered a duplicate number | Excel Discussion (Misc queries) | |||
| opening an excel file opens a duplicate file of the same file | Excel Discussion (Misc queries) | |||
| How do I prevent duplicate numbers from being entered in a column. | Excel Discussion (Misc queries) | |||
Linear Mode
