Excel Comparison Formula for Table Values

Problem Statement

To compare values between two tables in Excel and show the difference in value, you can employ a simple formula. This will allow you to identify discrepancies in corresponding values efficiently.

Assumptions

• Table 1 is located in range A1:A10.
• Table 2 is located in range B1:B10.
• The differences are to be calculated in Column C (C1:C10).

Excel Formula

To calculate the difference between the corresponding values in Table 1 and Table 2, use the following formula in cell C1:

=A1-B1

Instructions

1. Input the formula: Click on cell C1 and enter the formula above.
2. Drag down: To apply the formula to the rest of the cells in Column C, click and drag the fill handle (the small square at the bottom-right corner of the cell) down to cell C10.

Formula Explanation

• A1: Refers to the value in Table 1 (first value).
• B1: Refers to the value in Table 2 (first value).
• =A1-B1: This expression subtracts the value in cell B1 from the value in A1. The result will be the difference between the two values.
• When dragged down, Excel automatically adjusts the cell references (A2-B2, A3-B3, etc.) for each subsequent row.

Practical Example

Result Analysis

• In C1, the difference is 3 because 10 - 7 = 3.
• In C2, the difference is -5 because 15 - 20 = -5.
• In C3, the difference is 0 as both values are equal.
• In C4, the difference is 10 since 25 - 15 = 10.

Conclusion

This simple formula effectively computes the differences between corresponding values in two separate tables. By understanding and applying this formula, users can easily track discrepancies and analyze comparative data across tables in Excel. For enhanced Excel skills, consider exploring courses available on the Enterprise DNA Platform.