Help needed to generate a “best of 3” formula

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!)

Hi again,

Have a go with the following attempt ...

HTH
Carim

Ok – we’re getting there but not still quite there yet.

The function still isn’t perfect. If I type in L L in C6 and D6 the right hand side columns no longer gives values and Player B’s name does not carry though to Main Tournament 2.

If I accidentally type in the wrong result (very easy to do) I cannot go back and correct it – that could cause huge problems.

This clean button is useful now but highly dangerous on the end product because it could wipe the entire tournament at the touch of a button.

Agg, now we got visual basic editor in there as well – another application I know nothing about. I don’t wish to sound ungracious but I’m no computer programs expert – can we keep this all simple and just use excel formulas and conditional formatting?

Hope you’re still willing to help,

Mike