Copy data from 1 sheet to another

msp

New member
Joined
Mar 12, 2013
Messages
2
Reaction score
0
Points
0
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.
 

Attachments

  • Book1.xlsx
    10.6 KB · Views: 23
Try in C1

=IFERROR(INDEX('Q&A'!B$1:B$1000,MATCH($A1,'Q&A'!$A$1:$A$1000;0)),"")

Copy down and across.
 
Hi

thanks for your suggestion. I will try later today and confirm.

Regards
msp
 
Back
Top