DRSteele

Ranking with Tiebreakers

DRSteele

Well-known Member
Joined
Mar 31, 2015
Messages
2,667
Office Version
  1. 365
Platform
  1. Windows
DRSteele submitted a new Excel article:

Ranking with Tiebreakers - Using a new statsitic, we can rank performance by using cascading tiebreakers


Read more about this Excel article...
 

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.
Hi Don

I have used similar concepts for ranking previously, including sometimes decimal digits, particularly for categories where a lower value actually ranks higher.

However, I think your article would be better if it included a caveat about the size or number of categories, as the following statement makes it sound like there is no limit.
Note that other data sets can have more or fewer tie-breaking categories, to be sure.

Your example results in a Grade figure with a maximum of 14 digits, conveniently just under the Excel limit for significant digits. If we take the quote above and add one more category with a magnitude of 3, then the Grade figure exceeds the significant digit limit and the ranking is no longer reliable. Another example, rather than introducing another category is to simply change Qay and Pat's Sales level to 81000 & suddenly their ranking is equal, even though they still differ in Rustproofing Contracts.
 
Hi Peter,

Thanks for your comments. I actually have written about this before where I used the cascading categories as part of the decimal for Grade (meaning that I divided rather than multiplied the lesser categories). That too did mean a fourteen-digit precision limit. I will amend the article accordingly.
 
When I want a tiebreaker, I add a column numbered 1,2,3,4,5 down the page, and I add that number divided by a large number (eg 1000000) to the number (or text) I am ranking, and rank on the result. This always breaks ties.
 

Forum statistics

Threads
1,226,453
Messages
6,191,134
Members
453,642
Latest member
jefals

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