Ways of marking a total match
Posted
by
user331898
on Super User
See other posts from Super User
or by user331898
Published on 2014-06-10T01:31:04Z
Indexed on
2014/06/10
3:30 UTC
Read the original article
Hit count: 321
microsoft-excel-2010
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.
© Super User or respective owner