Excel Formula Question
Try...
C1, copied down:
=ISNUMBER(MATCH(B1,$A$1:$A$6,0))+0
Hope this helps!
In article ,
Mark wrote:
Can someone tell me what my function would look like. I have two column of
data, A and B. What I'm trying to do is figure out how much commonality I
have between the two. I would like a function that would compare column B
with A and give me a 1 or a 0 in Column C. 1 would equal common and 0 would
equal not common.
A B C
2 4 1
3 9 0
4 2 1
5 11 0
6
7
|