I have an assessment workbook for employee incentive rewards it lists the top ten point winners using regular ranking formula
Place Points Name
1 19 Tom
2 16 Dan O
3 15 Dan P
3 15 John
5 14 Greg
5 14 Lucas
7 13 Wawro
7 13 Mario
9 12 Mike
10 11 Peter
formula used( =RANK(M5,$M$4:$M$13)
What I would prefer to see is
Place Points Name
1 19 Tom
2 16 Dan O
3 15 Dan P
(no number) 15 John
5 14 Greg
(no number) 14 Lucas
7 13 Wawro
(no number) 13 Mario
9 12 Mike
10 11 Peter
Can this be done??
Any help appreciated
Bookmarks