Rank issues

[mmode66]

Hi There,

My Rank formula isn't working properly and I'm not getting the proper results.
I don't mind duplicates which i can fix with some weighted adjustments.
I'm getting dupes with different point values which has me baffled.

Here's my formula: =IFERROR(RANK(AS3,AS3:AS104,0),"")

I'm new at Rank and am assuming I'm doing something really wrong here:

(Note: Totals is column AS)

[TABLE="width: 150"]
<colgroup><col><col></colgroup><tbody>[TR]
[TD]RANK[/TD]
[TD]Totals[/TD]
[/TR]
[TR]
[TD]97[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD]74[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]27[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]57[/TD]
[/TR]
[TR]
[TD]55[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]45[/TD]
[TD]21[/TD]
[/TR]
[TR]
[TD]59[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]65[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]86[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]49[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]38[/TD]
[TD]25[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]76[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]70[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]75[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]76[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]73[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD]46[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]41[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]29[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]33[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]40[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]39[/TD]
[TD]19[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]57[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]50[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]48[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]43[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]44[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]45[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]51[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]48[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]32[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]37[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]42[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD]31[/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]29[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]39[/TD]
[/TR]
[TR]
[TD]25[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]21[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]33[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]30[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]38[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]19[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]43[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]36[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]27[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]26[/TD]
[/TR]
[TR]
[TD]24[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]32[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]57[/TD]
[/TR]
[TR]
[TD]22[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]26[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]23[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]20[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]13[/TD]
[/TR]
[TR]
[TD]20[/TD]
[TD]12[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]39[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]18[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]34[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]53[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]41[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]17[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]54[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]28[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]46[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]48[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]15[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]22[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]14[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]16[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]10[/TD]
[/TR]
</tbody>[/TABLE]

 

[Eric W]

It appears you need to add the absolute reference indicator:

=IFERROR(RANK(AS3,AS$3:AS$104,0),"")

 

[mmode66]

Wow, "Rookie, party of one... your table's ready!" lol
Can't believe i missed that. Thanks for the help. Been racking my brain for an hour on this.
Guess i should check if it's plugged in next time lol

 

[Eric W]

That's an easy one to miss! Glad you got it working!