Ways of marking a total match
- by user331898
I have two columns of matched data. One column contains the ID and the other column contains if there was a match(1) or no match(0) with that ID. There would be times when the all rows with the same ID will have all matched values of 1 and there would times where there were a mix of 0 and 1. I would like a third column to indicate where I have the same ID and all matched values are 1. Sample of what I have below column number and title of column:
COLUMN 1: ID
COLUMN 2: Match=1,No Match=0
1 1
1 0
2 1
2 1
3 0
3 0
3 1
This is what I would like: COLUMN # & TITLE
COLUMN 1:ID
COLUMN 2: Match=1, No Match=0
COLUMN 3: All ID Match & Match=1
1 1 N
1 0 N
2 1 Y
2 1 Y
3 0 N
3 0 N
3 1 N
Is there a formula or way in excel 2010 that would make this possible? I would still like to keep the rows intact. Appreciate your help. Thank you in advance.
