Have you tried the Data->Remove Duplicates option available in Excel 2007?