Hi, I used conditional formatting to highlight duplicates. I now want to remove the non-highlighted(unique) values. Easy to follow steps without having to use a macro would help. thanks.