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!!!