How to filter duplicates in excel

Here are the steps to filter duplicates in Excel: Select a data range. Click Data tab > Advanced Filtering. Select the "Copy to other location" option and enter the range of cells where the filter results will be stored. Check the "Unique Record" checkbox. Click the "OK" button to complete filtering.

How to Filter Duplicates in Excel

Filtering Duplicates in Excel is very easy, just follow the below Steps:

Step 1: Select data
First, select the data range that contains the duplicates you want to filter.

Step 2: Use advanced filtering
Click the Data tab > Sort & Filter group > Advanced.

Step 3: Specify filter conditions
In the pop-up advanced filtering dialog box, select the "Copy to other location" option.
In the "List Range" box, enter the cell range where the filtered data will be placed.
Tick the "Unique Record" checkbox.

Step 4: Click OK
Click the OK button, and Excel will filter out the duplicates in the data and copy them to the specified cell range.

Note:

• By default, advanced filtering will copy all filtered records, including duplicates. This setting can be changed by unchecking the "Unique records" checkbox.
• You can also use the Conditional Formatting feature to highlight duplicates. Select the data range and go to Home tab > Styles group > Conditional Formatting > Highlight Duplicates.

The above is the detailed content of How to filter duplicates in excel. For more information, please follow other related articles on the PHP Chinese website!