Ranking employees

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have to rank a group based on there score in column B. This has to be
Dynamic. As the data in column B keeps changing every week the names in
column A have to be ranked.
A B C
David 99.8% 1
John 92% 2
Wlliam 91.5% 3
Michael 91.5% 3
Steven 90% 4
 
One play to try ..

Adapting from a post by Daniel M.
(re: http://tinyurl.com/8snkd )

Assuming the source numbers are in col B, in B1 down

Put in the formula bar for C1,
and array-enter (press CTRL+SHIFT+ENTER):

=IF(B1="","",RANK(B1,INDIRECT("B1:B"&COUNT(B:B)))-(COUNTIF(INDIRECT("B1:B"&C
OUNT(B:B)),">"&B1)-SUM((1/COUNTIF(
INDIRECT("B1:B"&COUNT(B:B)),INDIRECT("B1:B"&COUNT(B:B))))*(INDIRECT("B1:B"&C
OUNT(B:B))>B1))))

Copy C1 down to say, C50, to cover the max expected data in col B
The desired "continuous" rankings will be returned in col C until the last
value in col B, with blank rows ("") thereafter
 
Bob Phillips said:
Found another one Max?<BG>
Click to expand...
Yes, been using it for sometime now <g>. The previous free filehost
(flypicture.com) is still in mind / used though, should savefile.com be
down, as it was quite a bit recently. cheers.
 
Back
Top