How to filter duplicate data in excel

Follow the following steps to filter duplicate data in Excel: 1. Organize the data into a table, ensuring that each column represents a category and each row represents a record. 2. Select the column or range that contains the duplicate data you want to filter. 3. Activate the filter in the "Data" tab. 4. Uncheck "Select All" in the drop-down menu and select "Duplicate Values" under "Value Filtering". 5. Duplicate values ​​will be highlighted, by default on the same row.

How to filter duplicate data in Excel

Step 1: Prepare the data

Ensure that the data is organized in a table, with each column representing a different category and each row representing a record.

Step 2: Select data

Select the column or range that contains the duplicate data you want to filter.

Step 3: Activate Filter

• Go to Data in the Excel menu bar and click Filter.
• Click the down arrow in the column in which you want to find duplicate values ​​to activate the filter.

Step 4: Find Duplicate Values

• Uncheck "Select All" from the drop-down menu.
• Select "Duplicate Values" under "Value Filtering".

Step 5: View the results

Duplicate values ​​will be highlighted. By default, Excel highlights rows with duplicate values.

Advanced filtering options

• Unique values: Only show unique values.
• Duplicate values: Only display duplicate values.
• Unique but remove spaces: Ignore spaces and find only true duplicate values.

Tip

• Before filtering duplicate values, make sure the data is sorted.
• If you want to keep duplicate values, you can copy and paste the results into a new worksheet after filtering.
• To cancel filtering, simply click the down arrow again in the column that activated the filter and select Clear.

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