Sorting or Filtering by Color?

[redheadinlove]

Hi,

I have a spreadsheet with over 200000 records that is driving me bonkers. I am working on removing the duplicates, but some I need to keep, For example there are 5 of the same email but different name, I need to keep one.

I have highlighted the duplicates and to avoid having to scroll through the 200000+ records and delete them, I am trying to sort or filter by color. Whenever I try to do this though, it either freezes, or doesn't sort or filter properly.

Any suggestions or input would be greatly appreciated.

Thank you very much!

[redheadinlove]

Never mind. I just removed the duplicates and it did what I was trying to accomplish. I guess I didn't fully understand how removing duplicates works.