I have highlighted duplicate records in Col A using Conditional formatting.

I would like a macro to delete the rows containing non-duplicate records the are containied in Col A