How to check duplication in excel table

How to check duplicates in excel tables

Use countif function to find

Recommendation:《Excel Tutorial》

Enter COUNTIF($G$2:$G$21,G2) in the blank cell of the same row, and then scroll down to the last row of all data. $G$2:$G$21 is an absolute reference to the required search data range. The value 1 indicates that the data appears once without repetition, the value 2 indicates that there are two identical data, and the value 3 indicates that there are three identical data.

Select the data area, click Start - Sort and Filter - Filter, select value 2 and value 3, filter out all duplicate data, and mark it with color.

Click the filter drop-down box of the function column again and select Select All to display all data.

The above is the detailed content of How to check duplication in excel table. For more information, please follow other related articles on the PHP Chinese website!