Index Match to return second matching value from row 12

[kelle]

I'm working with a survey dataset that needs to be aggregated for analysis purposes. Right now I'm looking to identify all instances where different respondents answered a question with the same numeric answer from a multiple choice list, the number of respondents who answered with the same answer, and then a list of the numerical values that they answered with.

So basically, right now I have a data table that identifies which numerical value each respondent (total of 9 respondents) responded with for each question, with the numerical values ranging from 1-42.

Right now I have a table that looks like this:

	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV
2	Total	Respondents in Support	(formula in this column looks at data table in S2:BH12 to identify how many of the numerical values had X [listed in column BK] supporters)	1	2	3	4	5	6	7	8	9
3	9	Respondents	0	=IF($BM3<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK3,$S$12:$BH$12,0))) -- answer is 0, as BM3 is less than BN2	<strike></strike>
4	8	Respondents	1	=IF($BM5<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK5,$S$12:$BH$12,0)))<strike></strike> -- answer is 19 (the matching header from the first column in the dataset that states "8" as the subtotal)	<strike></strike>
5	7	Respondents	2	=IF($BM5<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK5,$S$12:$BH$12,0)))​ -- answer is 18 (the matching header from the first column in the dataset that states "7" as the subtotal)	HOW DO I GET THE COLUMN HEADER OF THE SECOND INSTANCE OF 7 in subtotal of the dataset?
6	6	Respondents	1	=IF($BM6<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK6,$S$12:$BH$12,0)))​
7	5	Respondents	1	=IF($BM7<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK7,$S$12:$BH$12,0)))​
8	4	Respondents	3	=IF($BM8<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK8,$S$12:$BH$12,0)))​	HOW DO I GET THE COLUMN HEADER OF THE SECOND INSTANCE OF 4 in subtotal of the dataset?​ <strike></strike>	HOW DO I GET THE COLUMN HEADER OF THE THIRD INSTANCE OF 4 in subtotal of the dataset?​ ​
9	3	Respondents	6	=IF($BM9<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK9,$S$12:$BH$12,0)))​	HOW DO I GET THE COLUMN HEADER OF THE SECOND INSTANCE OF 3 in subtotal of the dataset?​ <strike></strike>	HOW DO I GET THE COLUMN HEADER OF THE THIRD INSTANCE OF 3 in subtotal of the dataset?​ ​	HOW DO I GET THE COLUMN HEADER OF THE FOURTH INSTANCE OF 3 in subtotal of the dataset?​ <strike></strike>	HOW DO I GET THE COLUMN HEADER OF THE FIFTH INSTANCE OF 3 in subtotal of the dataset?​ ​	HOW DO I GET THE COLUMN HEADER OF THE SIXTH INSTANCE OF 3 in subtotal of the dataset?​ <strike></strike>	<strike></strike>
10	2	Respondents	6	=IF($BM10<BN$2,"",INDEX($S$2:$BH$2,MATCH($BK10,$S$12:$BH$12,0)))	HOW DO I GET THE COLUMN HEADER OF THE SECOND INSTANCE OF 2 in subtotal of the dataset?​ <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>	HOW DO I GET THE COLUMN HEADER OF THE THIRD INSTANCE OF 2 in subtotal of the dataset?​ <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike>	HOW DO I GET THE COLUMN HEADER OF THE FOURTH INSTANCE OF 2 in subtotal of the dataset?​ <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>	HOW DO I GET THE COLUMN HEADER OF THE FIFTH INSTANCE OF 2 in subtotal of the dataset?​ <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike>	HOW DO I GET THE COLUMN HEADER OF THE SIXTH INSTANCE OF 2 in subtotal of the dataset?​ <strike style="background-color: transparent; border-collapse: collapse; color: rgb(34, 34, 34); font-family: Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif; font-size: 13px; font-style: normal; font-variant: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: left; text-decoration: line-through; text-indent: 0px; text-transform: none; -webkit-text-stroke-width: 0px; white-space: normal; width: auto; word-spacing: 0px;"></strike><strike></strike>	<strike></strike>

<tbody>
</tbody>

Of course, there's like 4 separate posts on how to do this on ExcelJet, but it seems to be down for me no matter what computer I visit it from...

 

[kelle]

Scratch that, figured it out! Thank you!