Excel uses the Add Secondary column setting Countif to filter for duplicate data (value)

inserts a secondary column to the right of the Name column. In the auxiliary column with the name peer input formula =countif (E$2:E2,E2) returns the number of times the peer name appears from the first name to the current line, in the copy formula, the automatic filter is set for the secondary column, 2 represents the name appearing two times, and 3 represents the name 3. Here is an introduction to Excel using the Add Auxiliary column settings countif filter duplicate data (value), to see it!

Tools/raw Materials

Computer Excel

Method/Step

1, the Name column has more than 500 data, inside has duplicate name

2, right click on the right side of the name column, inserted in the pop-up menu, insert a blank column

3, Input function =countif (E$2:E2,E2)

4, click on the tick to complete the formula input

5. Double click here or drop down

6, click Insert Column First column cell, click Data, Filter, AutoFilter

7, click to filter down the triangle and then click on the 2 2 representatives have been two names

8, this is the repeated occurrence of the name of two times the result of the display

9, here Select a name in the secondary column to display all

The above is Excel use Add Auxiliary column set COUNTIF filter duplicate data (value) method Introduction, hope to be helpful to everybody!