Excel Formula Question
See your other post.
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
--
Dave Peterson
|