I have about 1,500 lines of data. I have color coded the data into three text colors (Red, Blue, and Black.) The data is copied from my outlook sent email folder. Each color was assigned to a separate search criteria from my sent box (I did this in order to ensure that I copied all of my sent emails that pertained to what I am working on.)

Duplicates that are the color need to be kept as they represent more than one email sent during the same day (the time stamp did not carry over.)

Duplicates that are different colors need to be deleted as they are repetitions of each other.

Does anyone have an excel formula that would do this?

Any help is appreciated.