Can someone please help me write a macro for a basketball league? We have four teams and 8 possible scenarios because of the following. TEAM A is matched against TEAM B while TEAM C is paired against TEAM D. Therefore, the possible scenarios are either A v. C and A or C wins or A v. D and A or D wins, or B v. C and B or C wins or B v. D and B or D wins.
A v. C winner = A
A v. C " = C
A v. D " = A
A v. D " = D
B v. C " = B
B v. C " = C
B v. D " = B
B v. D " = D
Think of the possible combination for a Final Four National Champion. I have attached a spread sheet FYI. Any suggestions?
Thank you,
GC
Bookmarks