M
ModelerGirl
Hi all,
I am trying to check whether cell values in one range (say A1:A10) are
contained in a second range (say A20:A30). I tried the formula
countif(A20:A30,A[row number])=1
which was supposed to return "TRUE" is the cell value in that row WAS
contained in the second range and "FALSE" otherwise.
But I sanity checked this, and it seemed to yield the wrong answer some
of the time. Could someone suggest a different formula that would
work, or correct this one?
Thanks so much for your help!
Kate
I am trying to check whether cell values in one range (say A1:A10) are
contained in a second range (say A20:A30). I tried the formula
countif(A20:A30,A[row number])=1
which was supposed to return "TRUE" is the cell value in that row WAS
contained in the second range and "FALSE" otherwise.
But I sanity checked this, and it seemed to yield the wrong answer some
of the time. Could someone suggest a different formula that would
work, or correct this one?
Thanks so much for your help!
Kate