6 ways to check two Excel tables

6 kinds of two Excel table check methods.

I. Use of consolidation to check

There is one feature that you don't use in Excel: Merging calculations. It can be used to quickly compare the differences between two tables.

Example: The following figure shows two tables to compare, one is the inventory table, the other is the Financial software export table. Require a comparison between the two tables to see if the same item is in the same inventory quantity, shown in the Sheet3 table.

Inventory table:

Software Export Table:

Action method:

Step 1: Select the A1 cell in the Sheet3 table, excel2003 version, execute the Data menu (excel2010 Data tab)-merge calculation. In the open window "function" select "Standard deviation", as shown in the following figure.

Step 2: Next to the Close window, select the Inventory table A2:C10 (the 1th column to include the comparison of the product, the last column is the number of comparisons), and then click the "Add" button will add the area to all references location.

Step 3: In the previous step, add the A2:C10 area of the financial software table. Label Position: Select leftmost column, as shown in the following figure.

After the above steps, click the button, you will find that the difference table in the Sheet3 has been generated, C column 0 indicates no difference, not 0 of the row is the difference we want to find products.