Skip to Main Content

Cleaning & Analyzing Data in Excel

This guide complements the Cleaning & Analyzing Data in Excel workshop

Removing Duplicates

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

 

Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial 4.0 International License.