| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scatterpoot not using X values properly -- using relative ranking | Charts and Charting in Excel | |||
| Ranking Equal Values | Excel Worksheet Functions | |||
| Pivot Tables - Ranking Values | Excel Discussion (Misc queries) | |||
| Ranking Values that Meet a Certain Criteria | Excel Discussion (Misc queries) | |||
| ranking an row of values | Excel Worksheet Functions | |||
Hybrid Mode
