Rank Error

[Guest]

I am getting unexpected results when using the RANK function on a column of
calculated results. A simple example demonstrates the unexpected behavior.

A B C D
29 27.2 1.8 1
39 37.2 1.8 3
29 27.2 1.8 1

The formulas are:
column C: =$A1-$B1
column D: =RANK($C1,$C$1:$C$3,0)

Any idea why this is not ranked as a 3-way tie (i.e 1,1,1)?

 

[Max]

Perhaps due to the underlying values in cols A and B ..

Try instead in C1: =ROUND($A1-$B1,1)
Copy down

This should "correct" the ranking in col D

 

[Guest]

That worked great - Thanks!

Perhaps due to the underlying values in cols A and B ..

Try instead in C1: =ROUND($A1-$B1,1)
Copy down

This should "correct" the ranking in col D

 

[Max]

You're welcome !
Thanks for posting back ..