| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
identify duplicate data upon entry of that data
Is there a way to identify an entry as a duplicate in the same column. For
instance, if 4310011192 is already entered in the column and I enter it again, an error will result, informing the user "Duplicate entry". I know you can do this in ACCESS by virtue of the primary key, but don't know how to do it in Excel. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting 2 colums of numbers and incremening them down | Excel Discussion (Misc queries) | |||
| Data entry too slow even with calc set to manual | Excel Discussion (Misc queries) | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Data validation to prevent duplicate entry. | Excel Discussion (Misc queries) | |||
Threaded Mode
