[HELP] me to remove duplicate values and leave that cell as blank

Hi,
as you can see there are some values in the cell A which are duplicated, what I want is to remove duplicated values and put those unique values either in cell B or in cell A, but I also want after removing duplicate cell should remain blank..
Attachment 392117

actually I have data which I want to make unique,

I know gurus are here to help Thanks for creating such a great forum.

please check this file with duplicated entries..actually cell has over limited characters in single cell, that's why count-if not working.
Remove duplicate values.xlsx

someone suggested that this can be done in VBA please help

You have some cells that this code does not recognize as values.

This code will countif each cell, if it is greater than 1 then it will add it to the Union Range.

Once the loop is completed it will clear the cells next to the new range.

Please Login or Register  to view this content.