Solved

Return Value from Column A Based on Column C

Posted on 2011-05-10
269 Views
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
Question by:fbmartinez

LVL 43

Accepted Solution

=index(A1:A4,match(max(C1:C4),C1:C4,0))
0

LVL 1

Author Comment

Can I have the data on say, Sheet A, and the result go into Sheet B? I would just add Sheet references?
0

LVL 43

Expert Comment

Yes
0

LVL 43

Expert Comment

and yes
0

LVL 1

Author Comment

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

LVL 1

Author Comment

0

LVL 43

Expert Comment

It would make it easier for me to demonstrate this to you if you upload a sample with two or three such sheets.
0

LVL 1

Author Closing Comment

Thank you for the timely responses!
0

Write Comment

Please enter a first name

Please enter a last name

We will never share this with anyone.

Featured Post

Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!