Dear experts,

I've a table. Column A is for account numbers. I put a formula in
"Validation" to prevent duplicate records. It works well whenever I input
numbers. However, it doesn't work when I pasted a duplicate numbers from
another workbook. In this regard, please advise how to fix this problem so
that column A will also reject duplicate numbers from paste function.

Thanks in advance.