Google Sheets - Custom script/macro to grade answers

We have a multichoice quiz with 8 options:
A) BCC
B) Dermatofibroma
C) Solar lentigo/Seb K
D) Vascular lesion
E) Melanoma
F) Nevus
G) SCC in situ or invasive
H) Other Benign
We have a quiz app that automatically grades which answer is correct from student responses.

However, we would like to do secondary analysis of the results. So that, for example, B, C, D, F, H = Correct and A, E, G is Incorrect. Can you make a formula / script that makes this fast and easy to do?

Answer key should be on another google sheet

I can use array formula but would be good to have an easier way to solve this without creating multiple columns (30).
About the recuiter
Member since Jul 25, 2017
Istvan
from Bergamo, Italy

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions