Rank issues

M

mmode66

New Member
Joined
Aug 14, 2018
Messages
22
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]
 

Excel Facts

Format cells as date
Select range and press Ctrl+Shift+3 to format cells as date. (Shift 3 is the # sign which sort of looks like a small calendar).
Sort by date Sort by votes
It appears you need to add the absolute reference indicator:

=IFERROR(RANK(AS3,AS$3:AS$104,0),"")
 
Upvote 0
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
 
Upvote 0
You must log in or register to reply here.

Similar threads

S
  • Solved
Individual Ranking
2
Replies
11
Views
433
sksanjeev786
S
K
  • Question Question
conditional formatting question
Replies
2
Views
563
kerm007
K
A
  • Solved
Count entry by time
Replies
3
Views
143
admvlad
A
J
  • Question Question
Removing blank rows based on cell value
Replies
2
Views
246
Peter_SSs
Peter_SSs
S
  • Question Question
Inventory disposal plan
Replies
3
Views
277
Spaceballs_the_fanboy
S

Forum statistics

Threads
1,223,099
Messages
6,170,108
Members
452,302
Latest member
TaMere

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top