Bracket Automation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am responsible for running the brackets at our tournament next weekend. I am trying to automate the process as much as possible.
If i have cell m9 as the team name and cell o9 as the score of team # 1 and cell m13 has the team name and cell o13 has the score of team # 2, then what formula would i need to put in cell p11 to take the team with the greatest score from the correct cell m9 or m13?

I will be using this formula throughout the bracket for three divisions.

Thank you for your help with this matter.
 
Thank you, Frank. That worked great.
I have one more question.

Cell M9 is POOL SEED #4. Cell M13 is POOL SEED #5. The team names are in cells V3-V7. I will put their POOL SEED # in cells U3-U7.
I would like cell M9 to look through cells U3-U7 and find 4 then pull the name next to it. i would like to use this in the rest of the bracket for the other seed positions.

Thank you.
 
Hi
if I understood you correctly enter the following in N9:
=VLOOKUP(M9,$U$3:$V$7,2,0)
and copy down
 
Back
Top