Substituting your array in place of ROW(INDIRECT("1:6")) and
array-entering the result works fine for me:
=COUNT(MATCH({2,5,234,"a",-10,"dce"},A2:F2,0))=6
In article ,
"Jack Sons" wrote:
What if the 6 elements of the range A2:F2 are not the neat 1 to 6 but, say,
2, 5, 234, a, -10 and dce? Must {2,5,234,"a",-10,"dce"} be put in the place
of ROW(INDIRECT("1:6"))?
I tried, I entered and array entered, but the formula in both cases results
in zero. Please help me further.
|