Remove Duplicates In Excel

This was done in Excel version 2007

Highlight the an area you want search or click on the highlight all button (CTRL A)

Click on the Data tab, then Remove Duplicates