joshnelsontn
New Member
- Joined
- Jun 3, 2014
- Messages
- 2
Hello,
I have a test I've created for new hires, and I need to identify which questions are answered incorrectly based off an answer column.
<tbody>
</tbody>=INDEX(A:A,MATCH("wrong",B:B,0)) will return "3", but my desired output will be "3, 6, 7" (or something similiar).
Any ideas?
Thank you!!
I have a test I've created for new hires, and I need to identify which questions are answered incorrectly based off an answer column.
Question: | Result: |
1 | correct |
2 | correct |
3 | wrong |
4 | correct |
5 | not answered |
6 | wrong |
7 | wrong |
8 | correct |
9 | correct |
10 | not answered |
<tbody>
</tbody>
Any ideas?
Thank you!!