LinkBack URL
About LinkBacks
I am looking for a formula to rank teams by their win loss record based on the number of games they have played.
Column "K" is a list of wins, column "L" is the number of losses and column "N" is the number of games played.
Jim O
I am looking for a formula to rank teams by their win loss record based on the number of games they have played.
Column "K" is a list of wins, column "L" is the number of losses and column "N" is the number of games played.
Jim O
Have you tried Wikipedia?
or
=K2/N2
Cheers,=K2/(K2+L2)
Last edited by ConneXionLost; 10-29-2011 at 07:32 PM.
Would you like to say thanks? Please click the: "Add Reputation" button, on the grey bar below the post.
Hi Jo505.
It seems you can sort by Wins and then by Losses. See example.
http://www.gcflearnfree.org/excel2003/22.2
and attached
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks