View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mark Mark is offline
external usenet poster
 
Posts: 989
Default Excel Formula Question

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