A
assws
Good Morning,
The data I have looks like this
Bob 193
Scott 193
Paul 204
Ringo 149
JohnL 148
George 172
Pete 148
Rodger 148
Keith 168
JohnE 118
Using RANK(B1,$B$1:B$10,1) I can get the ranks but when there is a tie
I want to get the average of the 2 values of the tie. So if the 2nd
place is a tie with the 3rd place then (9+8)/2 = 8.5. It also has to
allow for a three (or more) way tie for example the 7th, 8th and 9th is
a tie so (2+3+4)/3 = 3
result What I want
Bob 8 *8.5*
Scott 8 *8.5*
Paul 10 10
Ringo 5 5
JohnL 2 *3*
George 7 7
Pete 2 *3*
Rodger 2 *3*
Keith 6 6
JohnE 1 1
Thanks in advance
The data I have looks like this
Bob 193
Scott 193
Paul 204
Ringo 149
JohnL 148
George 172
Pete 148
Rodger 148
Keith 168
JohnE 118
Using RANK(B1,$B$1:B$10,1) I can get the ranks but when there is a tie
I want to get the average of the 2 values of the tie. So if the 2nd
place is a tie with the 3rd place then (9+8)/2 = 8.5. It also has to
allow for a three (or more) way tie for example the 7th, 8th and 9th is
a tie so (2+3+4)/3 = 3
result What I want
Bob 8 *8.5*
Scott 8 *8.5*
Paul 10 10
Ringo 5 5
JohnL 2 *3*
George 7 7
Pete 2 *3*
Rodger 2 *3*
Keith 6 6
JohnE 1 1
Thanks in advance