New to the forum and excel formulas...learning by searching and posting!
Found ranking and discovered how it handles ties.
Now I need help!
Attached is a sample file.
I've got it ranking based on points but I have several ties.
I would like to break these ties by a helper cell.
there is a note in the file.
If anyone has a second and can help me out....thanks in advance.
could you just add the 4 sets of values together and base it off that?
10+0+0+0=10
3+0+1+1=5
etc
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Adding could still result in a tie.
ex.
# Total 1st 2nd 3rd
#1 10 + 2 + 0 + 1 = 13
#2 10 + 0 + 2 + 1 = 13
#3 10 + 2 + 1 + 0 = 13
#1 & #3 should win the 1st tie as #2 has no wins and #3 should win the second tie as it has (1) 2nd
how about using 3 x points for 1st, 2 x for 2nd and 1x for 3rd?
# Total 1st 2nd 3rd
#1 10 + 6 + 0 + 1 = 16
#2 10 + 0 + 4 + 1 = 15
#3 10 + 6 + 2 + 0 = 18
test points.xlsThat would not work as 3 3rd places would equal a single 1st.
The places should be broken with a 1st place being of greater value then any number of 2nds or 3rds.
Attached is an example of a 3 way tie for 1st.
working on this, and came across a second problem in your example, 8th place is also a tie, and no ranks(ie- 1st/2nd/3rd's) to separate them...how do you intend to separate them?
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
test points.xls
Attached is a sheet with a tie breaker all the way down to 10th place.
all ties broken by the highest indivual placing of any single placing....the tie for 8th would be won by #17 with 1) 5th place.
well, going through the data once more...first SHOULD actually belong to #10...1 win, 1 second... the last place should be considered a flyer...
Try this in AA3:
Formula:
Please Login or Register to view this content.
copied down
this in AJ3:
Formula:Please Login or Register to view this content.
copied down'
this is far more representative of the test data, and far less likely to produce any ties at all..
Hope this helps
Thank you for your help!
I'm sorry if I've confused anyone on my explanation...
The winner is the rider with the most accumulated points.
All ties should be broken by the highest placing of all individual sprints.
The attached file has a 3 way tie for 1st (based on points (21)) and a 2 way tie for 8th (again, based on points (12)).
ex. 1st place should be won by #15 with a total of 21 points and a single 1st place sprint breaking the tie with #14 & #16.
2nd place should be won by #14 with a total of 21 point and a single 2nd place sprint breaking the tie with #16.
3rd place should be #16 with a total of 21 points and (2) 3rd place sprint finishes
Down the list there is a tie for 8th place....
8th place should be won by #17 with a total of 12 points and (1) 5th place sprint finish
9th place should be #13 with a total of 12 points and (1) 6th place sprint finish
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks