How to Remove Duplicates in Excel in 2 easy ways
Removing duplicate entries is a very important step of data cleaning in Excel. Once all the duplicates are removed, it becomes easy to analyze your data.
We are going to look at two ways in which you can remove duplicates in Excel. In the first one, we will use the “Remove Duplicates” feature and in the second one, we will use the UNIQUE() Formula.
USING THE REMOVE DUPLICATE FEATURES
To remove duplicates in Excel, you can use the “Remove Duplicates” feature. Here are the steps to use this feature:
- Select the range of cells that you want to check for duplicates.
- Go to the Data tab in the ribbon, and click on the “Remove Duplicates” button.
- Excel will then display a dialog box showing you which columns have duplicate values.
- Select the columns that you want to check for duplicates and click OK.
- Excel will then remove all the duplicate rows, leaving only unique values.
Note: If you want to remove duplicates in a single column, you can select that column instead of the whole range.
USING THE UNIQUE FORMULA
You can use the UNIQUE function in Excel to remove duplicates from a range of cells. Here’s how:
- Go to the cell where you want your table to be.
- Type =UNIQUE and add the range of cells in the brackets (), for example, UNIQUE(C5:G21), and press enter.
- Excel will return an array of unique values from the selected range.
Another way is using the Advanced Filter option.
- Select the range of cells that you want to remove duplicates from.
- Go to the Data tab, and click on Advanced Filter option.
- In the dialog box, choose “List range” as your selected range, and check “Unique records only”
- Click OK, it will remove all the duplicate rows, leaving only unique values.
You can watch the full tutorial on Youtube