Data Sorting Two Colums:

[The Shadowman]

I have two columns that I would like to sort so that a best score matches the name achieving the best score. The first column is a simple list of names in text format, the second uses the RANK formula to list the scores taken from another part of the sheet. It works quite well, but the scores, for example, first place is not at the top, but down the list next to the name who achieved that score and so on for 2nd 3rd etc. What I would like is for Excel to place the best score at the top with the rest decending. At the same time the top scoring name should be moved up as well. Please see uploaded image.

No matter what I try I can not make it work. Is it possible, please?

Thanks in advance

Robert

 

[jasonb75]

Best guess is that it should be, I can't see any other errors.

=INDEX($C:$C,AGGREGATE(15,6,ROW($C26:$C$40)/($BD$26:$BD$40=SMALL($BD$26:$BD$40,ROWS(CP$26:CP26))),COUNTIF(CY$26:CY26,CY26)))

 

[The Shadowman]

Thanks again. My league works well now with your appreciated help. However, there is one more thing I would like to add. I would like to include trend up and down arrows and was wondering if you could guide me in the right direction, please.

Robert

 

[jasonb75]

For something like that you would need the data for current and previous to compare, then you could likely do it with conditional formatting. As it is a completely different question to the original one it would be best asked in a new thread.