I have 11 values (survey rating averages) and each are linked to
string (answer to survey). I want to make a area on my spreadshee
that will show which answer got the highest rating without having t
sort all the time or use VB. Is this possible? I was thinking o
somehow using the RANK command along with a LOOKUP command. On
problem that I see happening is that sometimes 2 answers get the sam
score and therefore have the same rank output from the RANK command.
Any thoughts?
Zac

--
OlYeller2
-----------------------------------------------------------------------
OlYeller21's Profile: http://www.excelforum.com/member.php...fo&userid=3630
View this thread: http://www.excelforum.com/showthread.php?threadid=56087

Not to sure why you are posting a specifically non-programming question in
the programming section... but no matter. Have you considered using a pivot
table. One of the advanced options for a field (such as you survey answer) is
to display the Top n results. Specify it to be 1 and specify the rating as
the criteria for the filter and off you go...
--
HTH...

Jim Thomlinson


"OlYeller21" wrote:


I have 11 values (survey rating averages) and each are linked to a
string (answer to survey). I want to make a area on my spreadsheet
that will show which answer got the highest rating without having to
sort all the time or use VB. Is this possible? I was thinking of
somehow using the RANK command along with a LOOKUP command. One
problem that I see happening is that sometimes 2 answers get the same
score and therefore have the same rank output from the RANK command.
Any thoughts?
Zach


--
OlYeller21
------------------------------------------------------------------------
OlYeller21's Profile: http://www.excelforum.com/member.php...o&userid=36309
View this thread: http://www.excelforum.com/showthread...hreadid=560874

Thanks for the help tough guy.


--
OlYeller21
------------------------------------------------------------------------
OlYeller21's Profile: http://www.excelforum.com/member.php...o&userid=36309
View this thread: http://www.excelforum.com/showthread...hreadid=560874