Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Prevent Duplicate Records
Dear experts,
I've a table. Colum A is for account numbers. I set a formula in "Validation" to prevent duplicate records. This works well whenever I input numbers. However, when I copy a number from another workbook and paste it to column A, the formula does not work even the number is a duplicated number. In this regard, please advise how to remedy this problem so that duplicate numbers pasted are rejected by the formula in column A? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete records when certain records have duplicate column data | New Users to Excel | |||
Prevent Duplicate Records | Excel Discussion (Misc queries) | |||
HOW CAN I PREVENT DUPLICATE ENTRIES WITHIN A WORKBOOK, i.e. job # | Excel Discussion (Misc queries) | |||
How do I prevent duplicate data in Excel? | Excel Discussion (Misc queries) | |||
Prevent duplicate entries | Excel Worksheet Functions |