What I'm looking to do is find a formula to count a range as 1 if it contains or does not contain certain values.
For example: I have the following 2 columns
Column 1......Column 2
C........................C
X........................N
1........................N
1........................X
1........................N
1........................N
What I want is:
if the column contains a "N" anywhere it but no 1's in that column to count if as a 1.
If the column contains an "N" and a "1" to count it as a zero.
So with my example the formula should return a "0" for Column 1 and a "1" for Column 2.
Any help is appreciated.
Thanks
Kathie
Bookmarks