Hi everyone,
The purpose of this question is to return values for an interview survey
The values that each of the 30 respondants could say for the 8 questions asked would be 1,2,3,4,5 to reflect their opinions. I want to be able to easily return everyone's name who said 1, everyone who said 2, everyone who said 3, etc. for each question of the survey.
I have tried tinkering with VLOOKUP and MATCH/INDEX to do this, but am not getting anywhere.
Does anyone have any insight as to what the proper protocol is?
The purpose of this question is to return values for an interview survey
The values that each of the 30 respondants could say for the 8 questions asked would be 1,2,3,4,5 to reflect their opinions. I want to be able to easily return everyone's name who said 1, everyone who said 2, everyone who said 3, etc. for each question of the survey.
I have tried tinkering with VLOOKUP and MATCH/INDEX to do this, but am not getting anywhere.
Does anyone have any insight as to what the proper protocol is?