• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sort list based on the score of each cell (duplicates scores happen)

C

cacos

Member
Hi everyone! I have a list that changes dynamically, I'm struggling in finding a formula/array that will sort it based on the scores. Important: There can be duplicate scores, here's when it gets complicated.


For example:


Team 1 - 26%

Team 2 - 60%

Team 3 - 94%

Team 4 - 17%

Team 5 - 60%


What I'd need is a formula that can get that list sorted starting from the highest score.


Thanks!
 
Hi ,


You have not mentioned what the complication is when there are duplicates. What do you want should happen if there is more than one team with the same score ?


Narayan
 
Practically, if any team has duplicates I dont care how it's sorted as long as they are there. Right now I'm using a formula combination with 2 helper columns that when there are duplicates on the scores, it only picks up one team name and repeats it.
 
You must log in or register to reply here.
Back
Top