Rotating "tables" as in pool table assignments for tournament

%3CLINGO-SUB%20id%3D%22lingo-sub-1553424%22%20slang%3D%22en-US%22%3ERotating%20%22tables%22%20as%20in%20pool%20table%20assignments%20for%20tournament%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553424%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20help%20finding%20a%20formula%20or%20combination%20of%20formulas%20to%20%22auto-assign%22%20the%20next%20available%20pool%20table%20during%20tournaments.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20my%20brackets%2C%20once%20a%20match%20is%20completed%2C%20the%20winner%20is%20designated%20using%20a%20%22w%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20then%20like%20that%20pool%20table%20number%20to%20be%20assigned%20to%20the%20next%20available%20match.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EUsing%20this%20screenshot%2C%20when%20match%207%20is%20completed%20on%20Table%20%231%2C%20I%20need%20match%2011%20to%20show%20Table%20%231.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20used%20a%20combination%20of%20IF%20formulas%20to%20get%20this%20to%20work%2C%20however%20I%20can't%20get%20it%20to%20do%20so%20without%20changing%20the%20table%20assignments%20of%20the%20other%20matches%20already%20in%20play.%20(meaning%20if%20I%20complete%20match%207%2C%20using%20my%20formulas%2C%20match%208%20changes%20to%20table%201%2C%20match%209%20changes%20to%20table%202%2C%20match%2010%20changes%20to%20table%203%2C%20and%20match%2011%20then%20shows%20as%20table%204%2C%20and%20I%20need%20match%2011%20to%20show%20table%201%2C%20and%20the%20other%20matches%20not%20to%20change%20once%20assigned.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%20would%20be%20appreciated.%20Thank%20you.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Tom_Witzman_0-1596035769282.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F208819iE2091D9A0CADE2F9%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Tom_Witzman_0-1596035769282.png%22%20alt%3D%22Tom_Witzman_0-1596035769282.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1553424%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1553621%22%20slang%3D%22en-US%22%3ERe%3A%20Rotating%20%22tables%22%20as%20in%20pool%20table%20assignments%20for%20tournament%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1553621%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F743725%22%20target%3D%22_blank%22%3E%40Tom_Witzman%3C%2FA%3E%26nbsp%3Bwell%20it%20could%20be%20done%20using%20a%20macro%20or%20if%20you%20added%20a%20timestamp%20to%20the%20finish%20of%20the%20game.%26nbsp%3B%20BUT%20if%20you%20can%20accept%20that%20match%2011%20will%20use%20table%201%20whenever%20match%207%20is%20done%20(which%20also%20makes%20the%20contestants%20know%20where%20they%20will%20play%20ahead%20of%20time)%20then%20that%20formula%20is%20very%20possible.%26nbsp%3B%20So%20it%20isn't%20that%20the%20next%20match%20number%20will%20necessarily%20be%20the%20next%20match%20to%20start%20but%20rather%20start%20as%20soon%20as%20the%20preceding%20match%20using%20their%20%22assigned%22%20table%20finishes.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

I need help finding a formula or combination of formulas to "auto-assign" the next available pool table during tournaments.

 

In my brackets, once a match is completed, the winner is designated using a "w".

 

I would then like that pool table number to be assigned to the next available match. 

 

Using this screenshot, when match 7 is completed on Table #1, I need match 11 to show Table #1.

 

I've used a combination of IF formulas to get this to work, however I can't get it to do so without changing the table assignments of the other matches already in play. (meaning if I complete match 7, using my formulas, match 8 changes to table 1, match 9 changes to table 2, match 10 changes to table 3, and match 11 then shows as table 4, and I need match 11 to show table 1, and the other matches not to change once assigned.

 

Any help would be appreciated. Thank you.

 

Tom_Witzman_0-1596035769282.png

 

1 Reply
Highlighted

@Tom_Witzman well it could be done using a macro or if you added a timestamp to the finish of the game.  BUT if you can accept that match 11 will use table 1 whenever match 7 is done (which also makes the contestants know where they will play ahead of time) then that formula is very possible.  So it isn't that the next match number will necessarily be the next match to start but rather start as soon as the preceding match using their "assigned" table finishes.