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))}
Search JabSto ::




Custom Search