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

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

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

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