AutoSorting

[OlYeller21]

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

[Jim Thomlinson]

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

[OlYeller21]

Thanks for the help tough guy.