Code to find duplicate colors and keep only 1 entry

Assume I have a data in Column A (Rows 1:500) where I have given certain colors to different entries in column A.

However, when I run the code, I want entries with similar colors to get deleted except only one entry of its kind.

Is there a way I can achieve that?

Can your column A or your data be sorted?
Is there room for temporary data in column B or any other column?

This macro will put color of cells in column A into column B.
It then sort those 2 columns and delete all similar color but the first cell.
It then delete column 2.
If you have data past columns B, change the sort range A1:B500 to suit your data.

Please Login or Register  to view this content.

@ p24leclerc
Hey!! Thank you for the code. It worked!!

@jindon

Thank you for the code.. The code was perfect and extremely fast..

Just 1 query, can this be done to duplicate text or numbers too instead of duplicate colors???

Done!!

Thanx a ton..