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!
You should read it
- How to remove duplicates in excel
- How to filter duplicate data from 2 Sheets in Excel
- Find and delete duplicate data in Excel
- 2 ways to delete data, duplicate content in Excel
- How to Find Duplicate Data in Excel
- How to create duplicate data entry notifications on Excel
- Instructions for deleting duplicate contacts on Android
- Filter data that doesn't overlap in Excel - Filter for unique values in Excel
- Instructions for finding and deleting duplicate files on Windows
- Guide to find and delete duplicate photos in your computer using the Duplicate Images Finder
- How to delete duplicate slides on PowerPoint is very simple
- How to filter duplicate data on 2 Excel sheets