HomeApplicationOffice information

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!

5 ★ | 1 Vote

You should read it

May be interested

  • Guide to Automatic Filter and Filter detailed data in excelGuide to Automatic Filter and Filter detailed data in excel
    to search and create small data tables that meet some conditions as required into big tables, we have to filter those data.
  • Data filtering (Data Filter) in ExcelData filtering (Data Filter) in Excel
    instructions on how to filter data in excel. 1. simple data filtering 1 condition. step 1: select the data you want to filter - data - filter - the data column appears arrow containing the options: step 2: if you want to filter by a certain value, do the following: uncheck select a
  • Advanced data filtering in ExcelAdvanced data filtering in Excel
    instructions on how to filter advanced data in excel. data filter (automatic data filtering) allows you to filter data only on a single column or data field -> so it is limited when using data. excel supports the advanced filter feature that allows you to filter
  • How to filter data in ExcelHow to filter data in Excel
    your excel spreadsheet has a lot of data, so it's easy to process and search the data in your table. filter data by conditions, criteria you give, you will shorten the search time and data processing
  • Filter data in Excel with Advanced FilterFilter data in Excel with Advanced Filter
    in the process of working with data tables in excel, the filtering of data in the data tables is very necessary and often done. there are many ways to filter and functions to help you filter data in data tables.
  • How to use the FILTER function in ExcelHow to use the FILTER function in Excel
    if you regularly work with data sets in excel, you know how important it is to be able to quickly find the information you need.
  • Instructions for finding and deleting duplicate files on WindowsInstructions for finding and deleting duplicate files on Windows
    instructions on how to find and delete duplicate files on your computer with the most popular applications - help free up disk space on the system.
  • How to delete duplicate slides on PowerPoint is very simpleHow to delete duplicate slides on PowerPoint is very simple
    when you download powerpoint slides online, it may happen that some slides overlap, repeating content. if the powerpoint slide has multiple pages of content, manually finding duplicate slides is not feasible.
  • How to delete duplicate photos, the same photo on Android phonesHow to delete duplicate photos, the same photo on Android phones
    after a long time of use, our phones will have a lot of duplicate photos from applications, downloads, screenshots, ... they will consume a lot of space on our memory. if we manually filter and delete, it will take a lot of time and even take photos.
  • Filter PivotTable report data in ExcelFilter PivotTable report data in Excel
    teach you how to filter pivottable reports data in excel 2013 accurately and quickly. the original pivottable report created on demand helps you see the entire information of the data. in case you want to statistically follow a field

Office information