Hi Everyone,
I'm new here and I want to say thanks to everyone who might be able to help me with this, I'm no Excel expert and can't seem to figure out how to create a macro or a code to deal with this problem. I have a sheet with multiple rows and columns A through K. The cells in column A is unique, but all rows may have duplicates in multiple cells and columns. For ex. B11, D11, E11, F11 are all duplicate phone numbers. Is there a way to delete the duplicates with a code? I have tried the automatic "Remove Duplicates" but since the entire rows are not looking the same it won't work. I want to be able to highlight the duplicate values in each cell with for ex. "Conditional Formatting" and then delete all but 1 unique value.
Not sure if I'm making any sense, but I have looked everywhere for a solution, and this is my last stop in trying to fix this.
Any advise is appreciated.
Thanks!
Bookmarks