ranking values

[bosforus]

does anyone know of an efficient way to rank 10 values and place them in
descending order. for example, there are 10 teams in a league and at
the end of the season they've accumulated points based on their
performance. however, as they are listed now they are not in order
from 1st to 10th place. i just want to be able to hit a button (or
better yet, maybe there's a formula I could type in a cell) and have
them displayed in order from 1st to 10th. any ideas?

 

[Gary Keramidas]

in my example, the formula is in l6, tot_Points is a named range M6:M16. m6 is
team 1's points

=RANK(M6,ToT_Points)

just copy down

 

[Gary Keramidas]

i do have all you are requesing in a golf league score sheet. send me your email
and i can give you more info if you need it

 

[bosforus]

here's my email, thanks a ton for the help
(e-mail address removed)