ranking values
 

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

ranking values
 

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

ranking values
 

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

--


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

ranking values
 

here's my email, thanks a ton for the help



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