New to the forum...new to Excel formulas!
I've done some simple formulas but run into a catch!
How do I break a tie in a ranking?
Attached is a sheet I've created.
What I would like to have happen is, in the event of a tie, I would like a formula to go back to last value of the sum and use the highest rank to determine the winner.
Thanks for any help anyone might supply.
Could you give an example or two of what you mean for clarification?
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Hi Bryan O and welcome to the forum,
You have discovered that two scores that are the same rank the same. I'd do some more calculations on this and add a tiebreaker rule.
In golf it is called the scorecard playoff. For you I'd total the scores for the interger part of the score and then use the last half of the races for the hundredths etc.
See if the attached helps.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
(A) (B) (C) (D) (E) (F) (G) (H)
Total Rank
10 9 10 9 - - 38 (sumA2:F2) 2 (RANK(G2,G$2:G$3))
9 - 9 10 10 - 38 (sumA3:F3) 1 (RANK(G3,G$2:G$3))
I would like a formula that would break the tie using the last completed fields highest hand.
As an example, line 2 would be ranked #1 because E3 would have the highest rank in the last completed field.
Assuming we are looking at table in R3:AC102... and assuming that you have equal number of columns filled for all Riders..
add a helper column in AD3:
confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down.
Please Login or Register to view this content.
then in AE3:
If you have varying number of entries for each Rider, then add another helper column...Please Login or Register to view this content.
so in AD2:
copied downPlease Login or Register to view this content.
in AE2:
Please Login or Register to view this content.
confirmed with CTRL+SHIFT+ENTER not just ENTER and copy down
and in AF3:
and copied downPlease Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks