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