Assumptions...

A1:A10 contains the 'Team Name'

B1:B10 contains the 'Total Points'

Formula...

D1, copied down and over to Column E:

=INDEX(A$1:A$10,MATCH(LARGE($B$1:$B$10-ROW($B$1:$B$10)/10^10,ROWS(D$1:D1)
),$B$1:$B$10-ROW($B$1:$B$10)/10^10,0))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!

In article ,
"stevenap" wrote:

I have a simple spreadsheet that shows ten teams in rows with point totals.
How do I set this up so that the team with the highest total points is always
on top of the list with the other teams in descending order by point valve?