How to check whether the information in two tables is the same in excel

How to check whether the information in two tables is the same in excel: first copy the first table; then select the second table, right-click and select [Paste Special-Paste Special]; then click Select [Subtract] under [Operation]; in the end, except for cells showing [0], it means that the cell is different from the first table.

How to check whether the information in two tables is the same in excel:

1. Open one and need to check Excel file of information.

#2. Copy the first table: Frame selection-right click and select copy.

#3. Frame select the second table, right-click, Paste Special-Paste Special.

4. In the "Paste Special" dialog box, click "Subtract" under "Operation" and click "OK".

5. At this time, except for cells showing "0" in the cells in the second table, it means that the cells are different from the first table. In order to facilitate timely inspection, you can fill the cells with color.

Related learning recommendations: excel basic tutorial

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