Hello!
I'm an engineering student involved with Formula SAE, a student club in which we build a racecar every academic year. I am responsible for writing and correcting rules tests to evaluate whether a student is proficient enough to go to competition.
Long story short, I've been researching options to do the least amount of work possible to check these damn tests.
I'd like to write a for loop that compares two columns: the Key and the student's answers, and then return the number of cells in both the Key and Answers that match. For example:
Key | John Doe

A | A
C | B
D | C
C | D

and have it return "1" because only one of his answers match.

I'd like it to compare each value of John Doe's input to the Key, if it is true, add 1 to the counter. If it is false, add 0. At the end, I'd like it to return the counter number.
Is this possible? Is there a way to do it without VBA? While I'm very familiar with Excel, I'm a beginner in VBA code.