Breaking ties in a head to head contest

I am working on a wrestling round robin tournament bracket. What I need to do is determine place winners with the first tiebreaker being results from head to head matches. I've tried assigning points for wins, similar to hockey and several other methods, but when it comes down to how to efficiently rank the places I am struggling. I have set it up so it can be either a 5 or 6 man round robin, which means there could be a potential for multiple ties and tie breaker methods. Any help would be greatly appreciated.

Thanks for the quick reply. I had it formatted to fit onto 11x17 sheets for posting on walls, etc. All of the "working" data is below the pretty part. All of the data/ names in the round above is made up. To determine a winner it goes by total wins. If there is a tie in wins it goes to winner of head to head matches. If there would be three ties and no clear winner by head to head it will go to total falls(pins) and then by least points. I am fairly confident that once I get past the head to head comparison I can do vlookups and or ranks for the other tiebreakers.

I did enter the place winners as they should be with the current dummy values in the file.

The second formula is pointing to an empty cell as it will only be filled in if one of the wrestlers wins by a pin. I what my intention for this is that all of the scores/results will be added in the cells from C61:C104 and then they will automatically update in the "clean" brackets above for quick display/printing. I realized that I need to determine a better way to show if a wrestler has a pin in the upper round bracket results.

I do not mind undoing all of the work below as it hasn't lead to where I would like to go. I was trying to determine the "winner" in a three win tie scenario in the work below, but other than a tone of IF(OR or IF(ANDs I'm not sure if there is an easy way to compare the head to head result. I guessed that if I could make it work for three wins I could make it work for the other win totals be replacing in the win total in the appropriate place in the function. The work below look unorganized because I was trying different methods to try to get there.

Also, I am "cleaning up" how to display the fall/pin for each match in the upper brackets as I realized that I did not account for the scores automatically populating from below.

My ultimate goal, if it is even possible, is to have the place winners automatically entered/ranked based on the results of the tournament matches. The places are determined by the following criteria;

1-Number of wins
If there is a tie in wins, no matter if it is 2, 3 or 4 wrestlers at one win total or a combination of wrestlers at two different wins totals.

1st tiebreaker-result of head to head match
2nd-If there is no clear winner in a multiple tie scenario would be total number of falls
3rd tiebreaker is least number of points allowed in all of the matches.

In a 5 man round robin a wrestler with 4 wins will be the champ as there is no way for another wrestler to have four wins as well.
In a 6 man round robin a wrestler with 5 wins will be the champ for the same reason.
Also, in a round robin tournament only one wrestler could potentially have zero wins.


All of that being said, step one is determining the proper rank for wrestlers with the same win total/s.

I took a look at the file and when I changed one of the wrestlers win totals the formula did not work anymore. When I changed the match result the head to head results changed but did not adjust. I have uploaded the file you uploaded last with my changes in the match results highlighted along with what the places should be in green. The places in orange are what the formulas calculated.

In the highlighted file there is a three-way tie, but one of the wrestlers lost to the other two so the head to head tiebreaker works, if each of the three wrestlers had one win among the head to heads the next tiebreaker would then be used.

I also took out the references to the c drive in the formulas and all of the wins in the first sheet went to one. Not sure what happened there...

The first sheet is basically a dumping ground for the general info about the wrestlers. As there can be any number of brackets depending on the total number of wrestlers I am hoping to keep the calculations on one sheet so the sheet can be copied as many times as needed and updated with the wrestlers info.

I did update the file so that all of the cells above are driven by formulas and all of the changeable data would be added below in the box with the bold border. I also added check boxes for falls so the person updating the match results wouldn't have to type so much. I uploaded the updated file as well if you want to see what can be done in that file...

I added your formulas to the second sheet for the wrestlers in the bracket. The formula you have will be great for the points against tiebreaker, but not for the head to head.

In a tie we need to evaluate the result of the match between the wrestlers that are tied directly. The points scored in the match or if it was won by fall do not matter just the result. If there is a three way tie with all of the wrestler still having equal wins it would move to the next tiebreaker.

For ties it may be easier to imagine the tied wrestlers in their own smaller bracket.