Microsoft Office Tutorials and References

In Depth Information

Figure 15-4 shows an example.

The two ranges must be the same size and of the same dimensions.

This formula works by creating a new array of the same size as the ranges being compared. The IF function fills

this new array with 0s and 1s (0 if a difference is found, and 1 if the corresponding cells are the same). The

SUM function then returns the sum of the values in the array.

The following array formula, which is simpler, is another way of calculating the same result:

{=SUM(1*(MyData<>YourData))}