Help needed to generate a “best of 3” formula

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

Thanx for your attempt but names are not carrying through when I enter a 3rd result.

Are you running macros? I have no idea about marcos and got a warning message about them being present.

Sorry but you do have to accept macros ...

and inputing a W or a L in cell E6 does trigger what you requested ...

HTH
Carim

Thanx for your help on this Carim – ok – I’m not too sure about macros but I now have cell F12 working of if I put a W in cell E6.

But this isn’t quite right. Because it is a “best of 3” Player A could win matches one and two (cells C6 and D6) and thus qualify for the next round without playing match 3 (recordable in cell E6.) Or Player A could lose his first two matches and thus Player B would qualify.

Is there anyway this could be achieved without using macros to save me learning a whole new area of excel I have no idea about? (I’m struggling with formulas alone!)