I have looked at many Ranking Q & A’s in the forum but can’t find a formula which quite answers what I am looking for. I have a results grid and wish to Rank Names by most wins using the following criteria with a helper column:
1. Most wins
2. If equal on Wins (least number of Losses but with equal rank number)
3. If still equal, alphabetically - A to Z
Note that even although Fred has more losses and is placed behind Chas & Dave he is still equal on position 2 and lastly the W/ L Results are concatenated
Thanks for looking and I hope I have explained it a satisfactorily.