Filter duplicate data, delete duplicate data in Excel

For excel files with large volumes of records, duplication of data is very common, and if it is found and processed manually, duplicated data will take a lot of time and effort. So I introduce to you how to filter duplicated data with tools available in excel.

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.

Filter duplicate data, delete duplicate data in Excel Picture 1

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

Filter duplicate data, delete duplicate data in Excel Picture 2

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

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

Filter duplicate data, delete duplicate data in Excel Picture 3

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

Filter duplicate data, delete duplicate data in Excel Picture 4

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.)

Filter duplicate data, delete duplicate data in Excel Picture 5

Data table results after filtering:

Filter duplicate data, delete duplicate data in Excel Picture 6

Good luck!