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" wrote:

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?

--
Biff
Microsoft Excel MVP


"Ron" wrote in message
...
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