X
XLDiva
I am using the RANK() function to rank a column of values. The values are a
result of subtracting two other values. My problem is that if I rank the
result, I do not always get a tie for equal values. A simple example shows
the unexpected result
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 doesn't produce a 3-way tie (i.e 1,1,1)?
result of subtracting two other values. My problem is that if I rank the
result, I do not always get a tie for equal values. A simple example shows
the unexpected result
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 doesn't produce a 3-way tie (i.e 1,1,1)?