Microsoft Office Tutorials and References

In Depth Information

=IF(COUNTIF(NameList,TheName)>0,”Found”,”Not Found”)

Figure 15-3:
Using an array formula to determine whether a range contains a particular value.

Counting the number of differences in two ranges

The following array formula compares the corresponding values in two ranges (named
MyData
and
YourData
)

and returns the number of differences in the two ranges. If the contents of the two ranges are identical, the for-

mula returns 0.

{=SUM(IF(MyData=YourData,0,1))}