Score a list of numbers

[DJ Dusty]

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!

 

[Guest]

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)

 

[Beege]

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,

Check out "=RANK"

Its neat for what you need.

Beege

 

[Peo Sjoblom]

Look at the RANK function


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com