I tried to do something like that with Excel and did something like what Peter says, except the filter doesn't delete anything it just hides them.
The only way I could actually delete the duplicates was to do the filter then copy and paste the result into another spreadsheet, which seemed kinda gay. But then maybe I was doing it wrong.