| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Duplicates
Daniel:
Tks I will try it Damon "Daniel CHEN" wrote: Use menu data validations select "Custom" from [allow] and type "=COUNTIF($A$1:$A$1500,A1)=1" in [Formula] Assume your input will be in column A range A1:A1500. "DamonG" wrote in message ... Is there a way that I could prevent DUPLICATES in a column in XL? Similar to a "Key" in Access. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Do not allow duplicates | Excel Discussion (Misc queries) | |||
| Duplicates | Excel Worksheet Functions | |||
| Condensing a list with duplicates to a list with non-duplicates | Excel Worksheet Functions | |||
| Duplicates in excel that aren't 100% DUPLICATES ... | Excel Discussion (Misc queries) | |||
| Help with Duplicates | Excel Worksheet Functions | |||
Threaded Mode
