Duplicate Data Identification in givin Excel Colums

[harinsh]

Hi All,

Can anyone will help me out with stated requirement. I need a macro code where if I enter same data (text or number) in any given column then I should get the error message or pop-up message. It also should be optional message not mandatory and excel need to allow to user enter same data however required the above control as well.

Looking forward for your solution.

Thanks
Harish

 

[njimack]

You don't need VBA for this. Go to Data>Validation. From the Allow list, choose Custom. In the formula box, enter the following, after amending it based to your ranges:
=COUNTIF(A:A,A4)<=1

Go to the Error Alert tab and change the Style to Warning.

 

[harinsh]

Hi nijmack,

sorry, still I can able to enter duplicate number/test in the column A and not getting any error message.

Please check and help me out.

Thanks