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