How to compare duplicate data between two worksheets

How to compare duplicate data between two worksheets: 1. Open the workbook and view the two worksheets inside; 2. Click "Data" - "Data Comparison" in sequence; 3. In the open drop-down menu , click "Mark Duplicate Values ​​in Two Areas"; 4. In the pop-up dialog box, select the two areas to be compared; set the duplicate color and click "OK".

The operating environment of this tutorial: windows7 system, WPS Office11.1.0.10314 version, Dell G3 computer.

First we open our workbook, which contains two more worksheet files.

Next we click on the data and find the "Data Comparison" button. click it.

We found "Mark duplicate values ​​in two areas" in the data comparison.

Next, a dialog box pops up, in which we need to select the comparison area.

#To delete the content, we select the area ourselves. After selecting both areas, find out what color to use to express the repeated colors.

Then click OK to complete the selection.

We can check the effect and see if the duplicate data is selected and marked.

Related learning recommendations: excel tutorial

The above is the detailed content of How to compare duplicate data between two worksheets. For more information, please follow other related articles on the PHP Chinese website!