Yes, in the Excel self-study column on techtipsnreview, CTV Nguyen Xuan Ngoc has also shown you how to filter and find duplicate data on Excel files.
To continue the unfinished topic and also to give you more options in finding and quickly processing duplicate data on Excel files, in today’s article I will introduce I will show you how to use the quick search tool and remove duplicates in your Excel file in the simplest and fastest way.
Read more:
1. Filter to find duplicate value field in cell or column in Excel
+ Step 1: You open the Excel file to be processed => Then scan and select vùng tiêu đề of the Excel file => select Tab Data => select tool Filter same picture.
+ Step 2: After choosing Filter => now in the title boxes will appear a triangle icon => you click and enter the content you need to search in that column => and press OK.
+ Step 3: Here, all the people in the list were born in 1990 will be displayed, along with other relevant parameters.
In case you search for a character field that is a letter, the returned results are all cells containing such characters. For example, I will find people named Dương in the list.
And the returned result will be:
2. How to delete duplicate data in Excel
+ Step 1: You scan and select the entire list area, the headers of the columns to delete duplicate data => then you click Remove Duplicates to perform deletion of duplicate character data.
+ Step 2: At the dialog box Remove Duplicates => you click to deselect the column headers that do not contain the characters to be processed to delete duplicate data, but instead you only tick the column headers that you choose to find duplicate characters to cancel => finally click to enter OK.
+ Step 3: The process of canceling duplicate data in columns is completed
At this point, the Excel file will display a message that has canceled the amount of duplicate data. Here you can click OK to agree.
Note: At this point, the order number in your list may be a bit messy, and you need to adjust this part to make the order number in Excel more reasonable.
The part of creating ordinal numbers for the list is probably familiar to many of you, so I won’t repeat it again. If you do not know, you can refer to the tutorial on how to quickly create ordinal numbers on your previous Excel file.
Epilogue
Ok, so I just introduced to you two tools to filter and remove duplicate characters when you copy or merge Excel files, I think this article I have presented very detailed and clear. that’s it
Here comes the tutorial Filter to find data and delete duplicate data in Excel I also ask for a pause. Hope this trick will be useful for your current job.
Good luck !
CTV: Luong Trung – techtipsnreview
Note: Was this article helpful to you? Don’t forget to rate the article, like and share it with your friends and family!
Source: Instructions to FILTER FIND and DELETE duplicate data in Excel files
– TechtipsnReview
