Solved How to have excel rank teams based on win/loss record

December 18, 2014 at 17:46:20
Specs: Windows 8
Column a team names rows 29:34
Column c wins rows 29:34
Column e losses rows 29:34
Column g rank rows 29:34

See More: How to have excel rank teams based on win/loss record

Report •

#1
December 19, 2014 at 04:39:39
✔ Best Answer
Use a "Helper Column".

Pick an unused column to calculate each win/loss record as a percentage and then use the RANK function in Column G to rank the percentages.

If there will be ties, there are workarounds. Do a Google search on breaking ties when using the RANK function. You'll have many options to choose from.

You can hide the Helper Column if you wish.

You can also perform the percentage calculation within the RANK function and not use a Helper Column. Your choice.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •
Related Solutions


Ask Question