How to Dedupe Records in Excel
Click on any cell in the spreadsheet., Click the Data tab on the Ribbon. , Click on the Remove Duplicates option.,Click OK
Step-by-Step Guide
-
Step 1: Click on any cell in the spreadsheet.
Doing so will select all the data in the database and open the Remove Duplicates dialog box.
When the dialog box opens, all of the column headings are selected by default.
To remove only those records from the database that match another record exactly:
Leave all column headings selected and Click OK.
To remove records from the database that have duplicate data in only one or more columns:
Remove the check marks from those columns you do not want to compare. , -
Step 2: Click the Data tab on the Ribbon.
-
Step 3: Click on the Remove Duplicates option.
-
Step 4: Click OK
Detailed Guide
Doing so will select all the data in the database and open the Remove Duplicates dialog box.
When the dialog box opens, all of the column headings are selected by default.
To remove only those records from the database that match another record exactly:
Leave all column headings selected and Click OK.
To remove records from the database that have duplicate data in only one or more columns:
Remove the check marks from those columns you do not want to compare. ,
About the Author
Debra Cole
Creates helpful guides on crafts to inspire and educate readers.
Rate This Guide
How helpful was this guide? Click to rate: