Home  >  Article  >  Topics  >  How to compare duplicate data between two worksheets

How to compare duplicate data between two worksheets

青灯夜游
青灯夜游Original
2021-04-23 17:12:58150175browse

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".

How to compare duplicate data between two worksheets

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.

How to compare duplicate data between two worksheets

How to compare duplicate data between two worksheets

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

How to compare duplicate data between two worksheets

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

How to compare duplicate data between two worksheets

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

How to compare duplicate data between two worksheets

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

How to compare duplicate data between two worksheets

How to compare duplicate data between two worksheets

How to compare duplicate data between two worksheets

Then click OK to complete the selection.

How to compare duplicate data between two worksheets

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

How to compare duplicate data between two worksheets

1How to compare duplicate data between two worksheets

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article:How to use table sum sumNext article:How to use table sum sum