In Excel 2003 and earlier versions, you can use an Advanced Filter to remove duplicates. In Excel 2007, there's a new command on the Ribbon to make it easier to remove duplicates from a list.

Be careful with the Excel 2007 Remove Duplicates feature though – it really removes the duplicates. If you use an [...]