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?