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)

RANKTotals
978
7414
5519
5519
2133
4820
2730
157
5518
4521
5917
6514
867
3825
4919
3825
2033
2629
7610
5715
4619
7011
759
767
7310
4619
4120
2132
1141
2032
2927
2329
5712
1933
4018
4018
3919
3222
5711
3222
4813
5012
4813
3320
943
3220
844
745
3218
517
448
2327
3217
1237
741
4211
1431
1529
839
2518
2123
3312
1330
938
1228
1920
643
836
1327
2015
1326
2412
932
157
2212
265
2311
1320
2013
2012
639
1024
1118
634
253
441
817
428
914
428
154
109
328
246
148
315
314
122
214
31
116
110

<colgroup><col><col></colgroup><tbody>
</tbody>
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
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

Forum statistics

Threads
1,213,559
Messages
6,114,302
Members
448,564
Latest member
ED38

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