This is what we have so far:
I have created a starting point and a dummy tournament League.
Formulas Used
Rank Formula
=RANK(F10,$F$10:$F$25,0)+COUNTIF(F10:F$10,F10)-1 Needs to be scrolled down through the Scoring Range
RANK looks through all of the scores from the Tournament tab and assigns a rank to that number compared to the other players scores.
Offset Formula
=OFFSET(E$10,MATCH(SMALL($G$10:$G$25,ROW()-ROW(E$10)+1),$G$10:$G$25,0)-1,0) Needs to be scrolled down through the Scoring Range
OFFSET looks at all of the scores from the Ranking column and assigns the players names in RANK Order.
IFERROR - INDEX - MATCH Formula
=IFERROR(INDEX($F$10:$F$25,MATCH(I10,$E$10:$E$25,0)),"")
INDEX looks through the Score column and matches the RANKED NAMES to the Players actual game score.
the IFERROR checks the values in the range for errors and returns the value or a blank if there is an error
To create a New Tournament Tab
Right click on the previous tab (6) name and select 'Move or Copy' then select 'Info' then check create a Copy
a new sheet will then be created at the end of the Tourney tabs. Change the data to reflect the New Tournament
To rename a Tab
Right click on the previous tab name and select 'Rename'
Bookmarks