Assigning point values?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Riptide - 23 Jul 2007 12:42 GMT

I have a list of (12) values that can go up or down on a daily basis. The
problem I have is that I need to assign a point value to see where each value
falls compared to the other values? Very Confusing I know, here is a short
example of whay I am trying to say:
Values
160
35
115
72
Based on this 160 would be assigned a value of 4, 115 a value of 3, 72 a
value of 2 and 35 a value of 1. Is there a formula that can do this or do I
need to figure this out on paper evertime the values change? I look forward
to any help.

Reply to this Message

Dave Peterson - 23 Jul 2007 12:48 GMT

Take a look at the =Rank() function in excel's help.

> I have a list of (12) values that can go up or down on a daily basis. The
> problem I have is that I need to assign a point value to see where each value
[quoted text clipped - 9 lines]
> need to figure this out on paper evertime the values change? I look forward
> to any help.

Signature

Dave Peterson

Reply to this Message

Toppers - 23 Jul 2007 12:54 GMT

Data in A1:A4:

in B1 and copy down

=RANK(A1,$A$1:$A$4,1)

assuming ranking values go from 12 to 1 in your list

Reply to this Message