| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Score a list of numbers
Is there any way I can score a list of 10 numbers from 1 - 10? IE: 52 44 131 63 64 36 28 132 108 80 Can another column score these in order from 1 to 10 (largest number gets 10, lowest gets 1) without performing a sort? So it would become: 52 = 4 44 = 3 131 = 9 63 = 5 64 = 6 36 = 2 28 = 1 132 = 10 108 = 8 80 = 7 Grateful for any help! -- DJ Dusty ------------------------------------------------------------------------ DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335 View this thread: http://www.excelforum.com/showthread...hreadid=528286 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Score a list of numbers
The Rank() function will score them for you. Duplicate #s can be an issue.
To get the nth largest number from a list use =large(list_range,n) "DJ Dusty" wrote: Is there any way I can score a list of 10 numbers from 1 - 10? IE: 52 44 131 63 64 36 28 132 108 80 Can another column score these in order from 1 to 10 (largest number gets 10, lowest gets 1) without performing a sort? So it would become: 52 = 4 44 = 3 131 = 9 63 = 5 64 = 6 36 = 2 28 = 1 132 = 10 108 = 8 80 = 7 Grateful for any help! -- DJ Dusty ------------------------------------------------------------------------ DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335 View this thread: http://www.excelforum.com/showthread...hreadid=528286 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Score a list of numbers
"DJ Dusty" wrote in
message ... Is there any way I can score a list of 10 numbers from 1 - 10? IE: 52 44 131 63 64 36 28 132 108 80 Can another column score these in order from 1 to 10 (largest number gets 10, lowest gets 1) without performing a sort? So it would become: 52 = 4 44 = 3 131 = 9 63 = 5 64 = 6 36 = 2 28 = 1 132 = 10 108 = 8 80 = 7 Grateful for any help! -- DJ Dusty ------------------------------------------------------------------------ DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335 View this thread: http://www.excelforum.com/showthread...hreadid=528286 DJ, Check out "=RANK" Its neat for what you need. Beege |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Score a list of numbers
Look at the RANK function
-- Regards, Peo Sjoblom http://nwexcelsolutions.com "DJ Dusty" wrote in message ... Is there any way I can score a list of 10 numbers from 1 - 10? IE: 52 44 131 63 64 36 28 132 108 80 Can another column score these in order from 1 to 10 (largest number gets 10, lowest gets 1) without performing a sort? So it would become: 52 = 4 44 = 3 131 = 9 63 = 5 64 = 6 36 = 2 28 = 1 132 = 10 108 = 8 80 = 7 Grateful for any help! -- DJ Dusty ------------------------------------------------------------------------ DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335 View this thread: http://www.excelforum.com/showthread...hreadid=528286 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| select numbers from a list and add to optimise result | Excel Worksheet Functions | |||
| find sum in list of of numbers | Excel Discussion (Misc queries) | |||
| find same numbers in a list in Excel | Excel Discussion (Misc queries) | |||
| How can I compare a number against a list of numbers | Excel Worksheet Functions | |||
| High score list? | New Users to Excel | |||
Linear Mode
