To remove duplicates, visit the DATA tab on the menu ribbon. Select the REMOVE DUPLICATES icon under the DATA TOOLS section.

You will be prompted to select the columns you want to --
- identify whether your data has headers
- select the columns you want to look across
