Need VBA code to remove entries if there are duplicates (remove them totally)

Here is the summary of what I need to do.
Task:-
I need to compare a row of numbers in column A from row 2 (row 1 is the header) till the end of the row with data.

If there are entries where there are duplicates, I need to delete them totally. I only need the numbers which are unique to remain.

Is there a VBA code to do this?

-Brandon

Would this work?
Try it on a copy of your workbook, just in case.

Please Login or Register  to view this content.

dilipandey has the proper solution.