Remove duplicate names

I often import 2 groups of Google contacts into one spreadsheet. The two groups often have duplicate names and I have to go through the spreadsheet and find/remove the duplicates.
It would be great to have an automated way to do this.