How do Excel2010 compare 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:
Excel2010
Software Export Table:
Excel2010
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.
Excel2010
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.
Excel2010
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.
Excel2010
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.