When we are using Excel, sometimes we will encounter multiple duplicate data, and then we need to delete these duplicate items and keep only one. So how do you do excel to delete duplicates and keep one?Today, I will explain to you how to set up Excel to find out the duplicate values and delete them, and users who need them to take a look at it. Excel** small class
Method 1
1. Select the ** area first, and click the [Data] option - [Delete Duplicate Values] in turn, and the dialog box to delete duplicate values will pop up.
2. Select one or more columns containing duplicate values in this dialog box, here we need to specify unique values, such as [Student ID], [Name], etc., we can check any of the checkboxes, or check all of them. That is, you can remove duplicate values and keep unique values.
Method 2
1. Select the ** area, or position the mouse in **, and click [Data] - Filter - [Advanced Filter] in turn, and the dialog box as shown in the figure will pop up.
2. Select the method [Copy the filter result to another location], so that we can make a comparison with the original **, select the a2:h12 range in the list area, the condition area is empty, no need to set, copy the result to the position at the beginning of a14, and check the [select non-duplicate records].
3. After clicking OK, the following filter results will be finally obtained!
Method 3
1.Position the mouse in **, click [Insert] - Pivot Table, and check [Existing Worksheet], and click the position where the pivot table is placed.
2.In the Pivot Table options, select the field as shown in the image.
3.Click [Design] - Report Layout - display in **, in [Total], select [Disable Rows and Columns], select [Do not show Classification Summary] in [Classification Summary], [Report Layout] - Repeat All Item Labels].
4.Back to [PivotTable Tool] - Analysis, the cancel button is displayed, as shown in the figure below, you can get the following table, the duplicate data has been successfully deleted, and the only value is retained.
The above is the operation method of excel to delete duplicates and keep one, I hope it will be helpful to all users.
Excel one-click to remove formulas and retain text Excel deletes formulas to keep arithmetic values.
How to check duplicates in excel How to find duplicates.
How to wrap in a box in excel How to wrap in the same cell in excel.
How to operate in the same grid of excel line wrapping excel one line becomes two lines up and down.