Forum Discussion
Clear duplicate content in xl column
I am trying to clear duplicate content in the cells in column B of my xl table. Remove Duplicates function is not suitable because it deletes rows. I only need to clear the duplicate content ...
My previous reply won't work if your data are in a table, since the data in a table row belong together. Deleting duplicates in a single column of a table makes no sense.
If you really need to do that, your data shouldn't have been in a table in the first place, so convert the table to a range. Then follow the steps from my previous reply.