Help needed to generate a “best of 3” formula

Here’s the situation: If a player wins 2 out of 3 matches s/he progresses to the next round in the main tournament and if a player losses 2 out of 3 matches s/he goes to the consolation tournament.

The wins and losses are typed into the excel spreadsheet as W or L.

How do I get excel to calculate that 2 out of 3 Ws equals an overall win and 2 out of 3 Ls equal an overall loss and then copy the winners name (which is on another cell) to the next slot and the losers name (also in another cell) to the consolation tournament slot?

I’d also like to know how to automatically grey out the cell of the losing player.

To make that all a little bit easier to understand please view this URL:
http://www.backpacker-backgammon.com...t_of_three.xls

Thanx in advance.

Mike

Hi Mike,

Sorry for such a stupid question, but i do not know the game ...
is 2 out of 3 a ratio ? or is it that a match is always made up of 5 games ?

Carim

Hi Carim,

Usually in a backgammon match it is the first player to a certain number of points (say 7) that wins the match.

However for this event it will be the best of 3 (7 point) matches.

I know how to program a single win / loss but this "best of 3" idea has me stumped.

Thanx,

Mike

Hi,

Do you plan to input 1,2,3 or W, L ... ?

Carim

W and L

These can be altered to whatever is required to make it work further down the excel spreadsheet out of view.

What do you think of this first attempt ...?

HTH
Carim