Ranking Scores with ties

B

bobdo

Help please - I have the following:
B C D E F G H I J
K L M N O
42 Total Points Won 6 9 8 10 6 5 9 7 6 8
6 7 8
(=rankc42,c$42:O$42,0) then replicate across and I get:
44 Scoring Rank 9 2 4 1 9 13 2 7 9 4 9
7 4
I then want a formula that I can go to the tie breaker points:
45 Tie Breaker Pts. 3 5 5 7 4 4 5 4 3 4
3 4 4
and get the following results:
46 Final Scoring Rank 10 2 4 1 9 13 2 7 9 5
10 7 5
in other words - to get a new ranking but any ties in that ranking stay ties.
Can anyone help me. Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scoring Rank with Tie Breaker 3
Arriving at totals 2
If Function 1
Ranking 3
Paragraph numbering in Word 1
ranking 1
Need help with sorting and moving to worksheets 1
Finding the right style field in VBA 0

Top