Returning multiple values from a range

ACNstrat

New Member
Joined
Dec 19, 2005
Messages
3
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?
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.
ACNstrat said:
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?

Are you trying to produce a table of results per question?
 
Upvote 0
ACNstrat said:
Yes, I think so, Aladin.

Just for Question 1 (Q1)...
aaCondSubListExtract ACNstrat.xls
ABCDEFGHIJKLM
131120
2NameQ1Q2Q3Q4Q112345
3eva1223evadanjonbrian 
4dan2131damon  karin 
5brian4321greg    
6jon3433     
7karin4313 
8damon1525  
9greg1121  
10
Sheet1


H1, copied across:

=COUNTIF($B$3:$B$9,"="&H2)

H2:L2 houses the answer set.

H3:

=IF(ROWS(H$3:H3)<=H$1,INDEX($A$3:$A$9,SMALL(IF($B$3:$B$9=H$2,ROW($A$3:$A$9)-ROW($A$3)+1),ROWS(H$3:H3))),"")

which is confirmed with control+shift+enter then copied across and down.
 
Upvote 0

Forum statistics

Threads
1,213,543
Messages
6,114,237
Members
448,555
Latest member
RobertJones1986

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top