Ranking

S

Saxman

I have a list of numerical data. I would like to give them a ranking as
in an example further down. It is possible?

Prob
0.186
0.175
0.171
0.165
0.16
0.159
0.14
0.137
0.133
0.126
0.116
0.094
0.093
0.062
0.172
0.141
0.138
0.137
0.129
0.117
0.094
0.092
0.214
0.19
0.184
0.132
0.107
0.157
0.144
0.135
0.133
0.119
0.119
0.118
0.112
0.11
0.098
0.094
0.093
0.093
0.092
0.075
0.068
0.065
0.065
0.065
0.062
0.059
0.221
0.195
0.169
0.128
0.038
0.036
0.035
0.128
0.117
0.095
0.092
0.089
0.083
0.065
0.065
0.059


Prob Rank
0.186 1
0.175 2
0.171 3
0.165 4
0.16 5
0.159 6
0.14 7
0.137 8
0.133 9
0.126 10
0.116 11
0.094 12
0.093 13
0.062 14
0.172 1
0.141 2
0.138 3
0.137 4
0.129 5
0.117 6
0.094 7
0.092 8
0.214 1
0.19 2
0.184 3
0.132 4
0.107 5
0.157 1
0.144 2
0.135 3
0.133 4
0.119 5
0.119 6
0.118 7
0.112 8
0.11 9
0.098 10
0.094 11
0.093 12
0.093 13
0.092 14
0.075 15
0.068 16
0.065 17
0.065 18
0.065 19
0.062 20
0.059 21
0.221 1
0.195 2
0.169 3
0.128 4
0.038 5
0.036 6
0.035 7
0.128 1
0.117 2
0.095 3
0.092 4
0.089 5
0.083 6
0.065 7
0.065 8
0.059 9
 
C

claus_busch

Hi,

Am Montag, 21. Oktober 2013 20:28:47 UTC+2 schrieb Saxman:
I have a list of numerical data. I would like to give them a ranking as

in an example further down. It is possible?
Click to expand...

your data in column A with header. Then in B2:
1
and in B3:
=IF(A3<=A2,B2+1,1)

Kind Regards
Claus
 
C

Claus Busch

Hi,

Am Mon, 21 Oct 2013 19:28:47 +0100 schrieb Saxman:
I have a list of numerical data. I would like to give them a ranking as
in an example further down. It is possible?
Click to expand...

your data in column A with header.
Then in B2:
1
In B3:
=IF(A3<=A2,B2+1,1)
and copy down


Regards
Claus B.
 
S

Saxman

Hi,

Am Mon, 21 Oct 2013 19:28:47 +0100 schrieb Saxman:


your data in column A with header.
Then in B2:
1
In B3:
=IF(A3<=A2,B2+1,1)
and copy down


Regards
Claus B.
Click to expand...


That works fine Claus. I am very grateful to you. Saves a lot of copy
and pasting!

Thank you.
 
Top