Filter Duplicate Data, Delete Duplicate Data in Excel

This article provides a clear overview of Filter Duplicate Data, Delete Duplicate Data in Excel, with the main facts, useful context, and practical details organized for easy reading.

For example, I have the following data table. The red records are marked as duplicates. What you need to do is find duplicate data and keep an original, delete other records.

Step 1: Highlight all the data you may need to filter Go to Data -> Remove Duplicate .

Step 2: The Remove Duplicate dialog box appears, selectable as follows:

- Filter all fields, click Select All -> OK .

- Filter each field you choose Unselect All -> select the fields you may need to filter -> OK .

Step 3: Microsoft Excel dialog box appears -> OK . (The dialog box informs the number of duplicate records, the number of records deleted and the total number of corrections after deletion.)

Data table results after filtering: