How to quickly and efficiently filter duplicates in Excel

When using Excel to process data, some duplicate data will inevitably appear. It is difficult to filter out the duplicate data, delete or mark it, etc. So is there any way to quickly filter duplicate content in Excel? Let’s take a look at the detailed operations below. How to filter duplicate content in Excel? 1. Take the table data in the figure below as an example to filter out duplicate content in the column;

2. Open the file, select the data column that needs to be filtered, and click the menu item [Start] - [Conditional Formatting] - [Highlight] Cell Rules] - [Duplicate Values];

3. Highlight the repeated values;

4. Select the data column and click [Data] - [Filter];

5. Click on the column title Drop down the small triangle and click [Filter by color] to see the duplicate data;

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