check two conditions in two different columns in excel and count the matches
- by user1727103
I've trying to create a Error Log to help me analyse my mistakes. So for simplicity, lets assume I have two columns "Type of Question" - with values SC,RC,CR and another column that indicates whether I got this question "right/wrong".Let's assume this is my table:
Question No. | Right/Wrong | Question Type
| Right | SC
| …