Macro for preventing of entering duplicates in column M

[bajramo]

Hi, I need to write a macro sub for preventing of entering duplicates in column M in excel.

Ex:

I enter "A - 100" in cell M5
If I enter "A - 100" in cell M7 I want to show me an error message that is duplicate.

[sourabhg98]

Invalid post - ignore

[bajramo]

are you sure?

The command is incomplete.

[sourabhg98]

I am really sorry posted that by mistake.
Select column A.
Goto DATA >> DATA VALIDATION >> CUSTOM
Enter this formula- =CountIf($A$1:$A1,$A1)=1

You can change the error message as per your requirement.
Also this would work only for typed values. So if you copy values from other cells this wont work.

[mso3]

Try this:

Please Login or Register  to view this content.

[mso3]

Hi bajramo,

If your problem is solved then mark the thread solved.