M
ModelerGirl
For example, suppose I have a range
1
2
3
4
5
and a second range
2
3
6
6
7
Is there a formula that would return a value of, say, 1 for each valu
in the first range that is NOT contained in the second range.
For example, here, I would want to return
1
0
0
1
1
Thanks very much,
Kat
1
2
3
4
5
and a second range
2
3
6
6
7
Is there a formula that would return a value of, say, 1 for each valu
in the first range that is NOT contained in the second range.
For example, here, I would want to return
1
0
0
1
1
Thanks very much,
Kat