[Calc bug? ] Function "RANK() " ranks error?

users
#1

Dear all:
I want rank some score.
There are 4 scores : 92.6, 93.6, 98.2 and 95.2
It's strange that the function "RANK() " rank 95.2 as "no. 1"

You can download this ods file to test:
https://sites.google.com/site/minhsien0330/test/RANK_PROBLEM.ods?attredirects=0&d=1

Is this a bug?

Thank you~

Regards Minhsien0330

#2

Your range is moved as well :

=RANK(B5;B5:B8)
should be
=RANK(B5;B2:B5)

Met vriendelijke groeten, Salutations distinguées, Kind Regards,

DRIES FEYS
CORPORATE SERVICES • Specialist Software Developer

TVH GROUP NV
Brabantstraat 15 • BE-8790 WAREGEM
T +32 56 43 42 11 • F +32 56 43 44 88 • www.tvh.com

#3

Hi minhsien0330,

There are 4 scores : 92.6, 93.6, 98.2 and 95.2
It's strange that the function "RANK() " rank 95.2 as "no. 1"

You can download this ods file to test:
https://sites.google.com/site/minhsien0330/test/RANK_PROBLEM.ods?attredirects=0&d=1

Is this a bug?

No bug!

Have a look at the references of your formulae in column C. I guess
you did copy the first formula in cell C2 down to C3, C4 and C5. If
you do so, you must declare absolute references instead of relative
references.

Change your formula in C2
from =RANK(B2,B2:B5)
to =RANK(B2,B$2:B$5)
before copying.

:slight_smile:

Cheers,
Stefan