How to filter duplicate values ​​in Excel table? How to filter out duplicates in excel table

Want to filter out duplicate values ​​from an Excel table? This tutorial will provide you with step-by-step instructions on how to easily identify and filter duplicates. If you are looking for solutions to organize and remove redundant data, please continue reading this article to learn about the simple guide provided by php editor strawberry.

　 How to filter out duplicates in excel tables

1. Use conditional formatting to quickly mark duplicate values ​​

1. Open Excel and select the data range that needs to be filtered.
　2. Select the "Home" tab in the Excel menu bar, and then click "Conditional Formatting".
　3. Select "Highlight Rules" in the drop-down menu, and then select "Duplicate Values".
　4. In the pop-up dialog box, select the style you want to use to mark repeated values, such as color fill, etc.
　5. Click "OK" and Excel will automatically mark the duplicate content.

　 2. Use the built-in function to filter duplicate values ​​

　 1. Create a new column to filter duplicate values. For example, if the data you want to filter is stored in column "A", you can create a new column in column "B".
　2. Use the following formula in the new column: =COUNTIF($A$1:$A$10,A1)》1. The meaning of this formula is to determine whether the current cell appears repeatedly within the data range.
　3. Apply the formula to the cells in the entire new column.
　4. Use the filter function ("Filter" button in the home page menu bar) and select "Yes" to filter out duplicate values.

　 3. Use the advanced filtering function

　 1. Select the "Data" tab in the Excel menu bar, and then click "Advanced".
　2. In the pop-up dialog box, set the target area of ​​"Copy to". This area is used to store the filter results.
　3. Select the data range to be filtered in the "Conditional Area".
　4. Select the column to be filtered in the "Condition Area" and select "Unique Value" in the "Condition" column.
　5. Click "OK" and Excel will automatically filter and copy the duplicate values ​​that meet the conditions to the specified target area.

　 4. Use sorting to filter duplicate values ​​

　 1. Select the data range to be filtered.
　2. Select the "Data" tab in the Excel menu bar, and then click "Sort".
　3. Select the column to be sorted in the pop-up dialog box, and then click "Add Level".
　4. Select "Value" in the newly added level and select "Remove Duplication".
　5. Click "OK" to complete the sorting.
　6. After sorting, the same values ​​will be arranged together, and you can manually select duplicate content for processing.

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