Re: Ranking a list

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Assuming that A1:A5 contains your score...

B1, copied down:

=SUM(IF(A1<$A$1:$A$5,1/COUNTIF($A$1:$A$5,$A$1:$A$5)))+1

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article <#lQprFsHGHA.1332@xxxxxxxxxxxxxxxxxxxx>,
"Bri" <bdorr@xxxxxxxxxx> wrote:

> Hi
>
> I have a list of values that I need to rank in descending order. Usually
> the RANK function is OK, but here is my problem. I need the list to use
> 'generous' rules. If there is a tie for 2nd, lets say, then I need the next
> place to be 3rd, NOT 4th as the RANK function does.
>
> eg
> Scores Rank(correct) Rank(wrong)
> 14.04 1 1
> 12.665 2 2
> 12.665 2 2
> 11.725 3 4
> 0.000 4 5
>
> Any ideas how I can deal with this situation?
>
> Thanks in advance
> Bri
.

Relevant Pages

  • Ranking a list
    ... I have a list of values that I need to rank in descending order. ... NOT 4th as the RANK function does. ... Bri ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Ranking Alphabetically
    ... cdavidson wrote: ... > I would like the rank function to produce the following results: ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • RE: Ranking
    ... see rank function ... "jtothet21" wrote: ... > I have a list of numbers in a spreadsheet and I want to have a column next to ... Prev by Date: ...
    (microsoft.public.excel.misc)