How can I automate a 16 man wrestling bracket in Excell.

[Bob Imhof]

Hi out there in cyberspace,

I am trying to automate a workbook containing 14 sheets, each is a weight
class used for wrestling tournaments. I want to be able to enter results and
have the losing wrestler move down and or out in a consolation bracket. This
is my first attempt at using =if, and so far I have had little success. My
attempt, recorded in cell B6 looks something like this =if(B5="True" and_or_
B7="True", Copy_B5 and_or_B7 To B49)

B5=Wrestler 1
B7= Wrestler 2
Loser drops to Cell B49

Any help or guidance would be greatly appreciated,

Bob Imhof
Ridgway, Pennsylvania

 

[Guest]

you are not going to do it that way.
formulas return values, they cannot perform actions like
copy. i would use a helper column, assign each wrestler
and index then sort by the index. that would move the
wrestler up and down the list.