rank()

[lezawang]

Hi
I am trying to use rank but it does not make sense how rank() function is ranking numbers.
in the example below. why for example 96332 and 96103 both have rank #1 !! should not be rank 1 and 2 respectively? thanks
ps: the function i wrote is =RANK(B2,B2:B25) then autofilled

[TABLE="width: 141"]
<tbody>[TR]
[TD]salary[/TD]
[TD]salary rank[/TD]
[/TR]
[TR]
[TD="align: right"]36583[/TD]
[TD="align: right"]20[/TD]
[/TR]
[TR]
[TD="align: right"]93600[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]73873[/TD]
[TD="align: right"]8[/TD]
[/TR]
[TR]
[TD="align: right"]96332[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]49703[/TD]
[TD="align: right"]14[/TD]
[/TR]
[TR]
[TD="align: right"]35773[/TD]
[TD="align: right"]16[/TD]
[/TR]
[TR]
[TD="align: right"]95949[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]25435[/TD]
[TD="align: right"]17[/TD]
[/TR]
[TR]
[TD="align: right"]96103[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]53585[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]76264[/TD]
[TD="align: right"]4[/TD]
[/TR]
[TR]
[TD="align: right"]44716[/TD]
[TD="align: right"]10[/TD]
[/TR]
[TR]
[TD="align: right"]28471[/TD]
[TD="align: right"]11[/TD]
[/TR]
[TR]
[TD="align: right"]51497[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]53918[/TD]
[TD="align: right"]6[/TD]
[/TR]
[TR]
[TD="align: right"]28280[/TD]
[TD="align: right"]9[/TD]
[/TR]
[TR]
[TD="align: right"]94823[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]92832[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]66356[/TD]
[TD="align: right"]3[/TD]
[/TR]
[TR]
[TD="align: right"]94180[/TD]
[TD="align: right"]1[/TD]
[/TR]
[TR]
[TD="align: right"]53771[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]51882[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]42281[/TD]
[TD="align: right"]2[/TD]
[/TR]
[TR]
[TD="align: right"]71548[/TD]
[TD="align: right"]1[/TD]
[/TR]
</tbody>[/TABLE]

 

[wideboydixon]

You didn't anchor the second range. Change it to this and autofill:

=RANK($B2,$B$2:$B$25)

WBD

 

[cunningAce]

Lock the range as such

=RANK(B2,$B$2:$B$25)​