Hi
I have a quiz which consists of 60 questions (multiple choice answers). The report that i am getting from the server only tells me the slide number and the answers given by the candidate. I dont know how to explain this hence i am going to use an example.
I have a workbook with 2 sheets. One is called "Result" and the other sheet is called "Q&A"
Result sheet is the one that I get from the server and it tells me the question number and the answer given by candidate.
Q&A is the sheet in which i have cut & pasted all the 60 questions along with answers.
Is there any way I can only show the data corresponding to the questions which candidate has answered? I am attaching a spreadsheet which will show what I am after.
Any help would be greatly appreciated.
I have a quiz which consists of 60 questions (multiple choice answers). The report that i am getting from the server only tells me the slide number and the answers given by the candidate. I dont know how to explain this hence i am going to use an example.
I have a workbook with 2 sheets. One is called "Result" and the other sheet is called "Q&A"
Result sheet is the one that I get from the server and it tells me the question number and the answer given by candidate.
Q&A is the sheet in which i have cut & pasted all the 60 questions along with answers.
Is there any way I can only show the data corresponding to the questions which candidate has answered? I am attaching a spreadsheet which will show what I am after.
Any help would be greatly appreciated.