Just wondering how I can make Excel find all duplicate records in a column? For example, if 2079999-A occurs 3 times in the same column, I would like the 2nd and 3rd ones hilighted so I can erase them. At the end of the day I just want no duplicates.

I could manually do it but the records are in the thousands and I'm hoping there's an easier way?

Thanks!