| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
? format column so no duplicate entries are accepted
Am attempting to set up database in Excel and need to format one column so
that it does not accept duplicate entries through the column? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
? format column so no duplicate entries are accepted
Select the column, in this example, column A.
Select Data | Validation... | Settings tab | Allow: Custom and put the folowing formula in the Formula box: =COUNTIF($A:$A,$A1)<2 You will now not be able to create a duplicat entry in column A Regards Trevor "Selina" wrote in message ... Am attempting to set up database in Excel and need to format one column so that it does not accept duplicate entries through the column? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| creating a bar graph | Excel Discussion (Misc queries) | |||
| Deleting All Rows for Duplicate Entries Except Those With Most Items In Row | Excel Discussion (Misc queries) | |||
| Finding duplicate cell entries in a column of data | Excel Discussion (Misc queries) | |||
| How do I set up an Excel column to not allow duplicate entries (m. | Excel Discussion (Misc queries) | |||
| Preventing Duplicate Entries within a column | Excel Discussion (Misc queries) | |||
Hybrid Mode
