2 Problems; need Help!!

[xrailbank]

I have 2 different problems I need help solving.

I run pool leagues and tournaments where I have tournament brackets composed in EXCEL using IF statements to determine the winners and losers of the match then moving them to the correct location for the next match.

PROBLEMS:
1) All of this works fine using individual names, players or teams. What I am looking for is a way to have an individual team name associated with the 5 to 7 players who exactly played in the match. Now this group of players might change for every match.

2) I have a group of 5 players, 1st 2 players to reach 4 wins mores forward to different brackets on the winners side and the 3 other player move to 3 different brackets on the 1 Loss side. Tried IF statements but way too many possiblities to work with.

Any thoughts to solutions to either or both of these problems would be appreciated.

Thanks

[Maistrye]

Your description of your first problem needs a bit of work. It probably makes sense when you can see some of the data, but based on what you've actually said, it's hard to determine what you want.

For the second one, the simplest way is probably macros. (Depending on your expertise, you'll need different kinds of help for this one.)

The easiest type of macro you could write for something like this is a User Defined Function. You set it up so that it takes a list of names and scores, and it returns the person in position X. Tell us what sort of help you'll need to accomplish this. Once you've implemented it, you can treat it just like any other function you use.

One question I'd have... what's the tiebreaker you intend to use should 3 people get to 4 wins? ie. 4-4-4-3-3.

Scott