Return Value from Column A Based on Column C

I am trying to compile results from a set of questions asked on a survey.

The responses are collected as individual sheets, each sheet containing 1 answer.

The answers look as follows:

Column A        Column B     Column C
1 only              0.0%           3
2 - 4 clicks      0.0%           7
5 - 7 clicks      100.0%           1
7+ clicks               0.0%           0

I would like to create a formula to into this sheet and return the max in column C, but the twist is that I want it to give me the label in Column A - NOT the value in Column C.

So my result would be: 2 - 4 clicks wherever on this sheet or on a different sheet.

Is this something I can do, and what would the formula be?

Thanks in advance for the help!!!
LVL 1
fbmartinezAsked:
Who is Participating?
 
Saqib Husain, SyedEngineerCommented:
=index(A1:A4,match(max(C1:C4),C1:C4,0))
0
 
fbmartinezAuthor Commented:
Can I have the data on say, Sheet A, and the result go into Sheet B? I would just add Sheet references?
0
 
Saqib Husain, SyedEngineerCommented:
Yes
0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
Saqib Husain, SyedEngineerCommented:
and yes
0
 
fbmartinezAuthor Commented:
Perfect. Now, I will need to ask another question on here, though I should probably open a new question altogether, if you'd like.

I have 130 different sheets, some with 2 answers, some with 4, 5, 6 I think 6 is my max number of rows.

What would be the best approach to getting these results back from each sheet? Would I need to go in an name each range or something?

I know I probably am not making sense.
0
 
Saqib Husain, SyedEngineerCommented:
It would make it easier for me to demonstrate this to you if you upload a sample with two or three such sheets.
0
 
fbmartinezAuthor Commented:
Thank you for the timely responses!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.