How Excel Compares 2 tables

how Excel Compares 2 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:

Excel tip: Two Excel table contrast methods

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.

Warm tips:

If you want to generate a specific number of differences, you can set the number of one table to be negative. (Add a secondary column =c2*-1), select sum in the merged function.