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


"bosforus" wrote in
message ...

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?


--
bosforus
------------------------------------------------------------------------
bosforus's Profile:
http://www.excelforum.com/member.php...o&userid=33621
View this thread: http://www.excelforum.com/showthread...hreadid=534006