Computing Staff
  • -1

How To Have Excel Rank Teams Based On Win/Loss Record

  • -1

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


1 Answer

  1. 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

    • 0