Sort highest by name

[Ron]

I have 55 teams in A1 to A55.
I have their scores in B1 to B55.
Is there a way to list the scores (highest to lowest) but giving their team
names instead of all the numbers in order of the highest to the lowest?
Help Obe 1

 

[T. Valko]

Why don't you just sort this data by column B in descending order?

Select the range starting from cell B1 then just click the sort descending
button on the toolbar.

If you don't want to sort the data then you could use a formula. Are there
any tie scores? What type of values are the scores? Are they whole numbers?
Decimals?

 

[Ron]

Hi Bill,
The scores are percentages. It's possible to have a tie but not if I had 2
decimal points to the percentages. I tried explaining as simply as possible
but I actually misled you. There is other data in columns and formulas in
some. It says, when I try to sort,"The operation requires merged cells to be
sized.". I was hoping that I could use a formula to avoid mixing other info.
Hope I'm clear. Ron

 

[T. Valko]

Assume you want the results to appear starting in cell E1.

Enter this array formula** in cell E1 and copy down to E55:

=INDEX(A$1:A$55,MATCH(LARGE(B$1:B$55-ROW(B$1:B$55)/10^10,ROWS(E$1:E1)),B$1:B$55-ROW(B$1:B$55)/10^10,0))

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

 

[Ron]

Beautiful! That is working just like I had imagined.
Thanks to all who helped with this.
Ron

 

[T. Valko]

You're welcome. Thanks for the feedback!