How to check if each value in a cell range is contained in a second cell range?

  • Thread starter Thread starter ModelerGirl
  • Start date Start date
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
 
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 value
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,
Kate
Click to expand...

=--(COUNTIF(rng2,A1)=0)


--ron
 
Back
Top