How to check duplicate data in two excel tables

How to check data duplication in two excel tables:

1. Enter countif in Sheet1, select the data to be compared, and then enter a "," Number.

#2. Enter the Sheet2 worksheet, select the data to be compared, and then press Enter.

3. The effect after drop-down filling is as follows

Recommended learning: Excel Basic Tutorial

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