Solved How to check if answers of pairs match in excel?

February 19, 2017 at 00:30:55
Specs: Macintosh
Doing research and need to check if pairs of twins have answered 3 question in the same way. Help much appreciated :)

A person has an own row, with personal code followed by answers.

I somehow need to match two codes and then see if the answers of these code pairs match.
ex.
XDX. 1, 0, 1
VGD. 1, 0, 1

Sunday greetings from a confused thesis writer

message edited by AnnieHuh


See More: How to check if answers of pairs match in excel?

Report •

#1
February 19, 2017 at 05:24:42
✔ Best Answer
First, a posting tip:

Please click on the blue line at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

Thanks!

For now, I am going to assume that your data looks like this:

      A      B     C     D
1    XDX.    1     0     1
2    VGD.    1     0     1

If that is the case, the following formula will compare B1 with B2, C1 with C2 and D1 with D2. If all of those comparisons are TRUE, the IF will be TRUE and the formula will return the word "Match".

The AND function requires that all logical tests within the parenthesis be TRUE for the AND to be TRUE.

=IF(AND(B1=B2,C1=C2,D1=D2),"Match","No Match")

If I am misunderstanding your question, just let me know.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •
Related Solutions


Ask Question