• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 318
  • Last Modified:

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!!!
0
fbmartinez
Asked:
fbmartinez
  • 4
  • 4
1 Solution
 
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
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
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

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now