How To Remove Duplicates In Excel 2016

How to Remove Duplicate Data in Excel 2016

It'southward a big hassle, just a common one: Your Excel spreadsheet contains duplicates and you need to weed them out. Don't worry. The steps below will assist you find duplicates (or even triplicates) in your spreadsheet and remove them.

Data duplication can happen when records are entered into the spreadsheet more than in one case (or you're combining records from multiple sources). You lot might as well detect duplicates for one or more fields--such equally a name or state field--with the same data and want to limit the records to unique data for some fields. Excel'southward built-in Remove Duplicates tool tin can help you get find and remove those duplicate records in one swoop.

i. Click on whatever cell in your spreadsheet that contains data.

2. Click the Remove Duplicates push button in the Data tab.

three. In the resulting window, select the columns you want to search for duplicates and remove and striking OK. By default, when the Remove Duplicates dialog box is opened, it volition take all the field names (columns) checked. Exit them all checked if you're looking for completely identical records in your spreadsheet or select only those columns you don't want to have duplicates for (ex:, in our case, if y'all want to take only i educatee per state in the spreadsheet, uncheck all the fields except "Home State").

4. Click OK after Excel scans for those duplicates in each field and deletes them for you. A new message volition tell you how many values were removed.