Tennis scoring macro

Hi,

Thanks for the reply.

I uploaded a quick sheet. I basically want it to follow the normal scoring rules of tennis, i.e. 0-15-30-40 for points, if it gets to 40-40 then we players have to win two points in a row to win a game (adv and then game).

Games are the same, so they have to win minimum of 6 games to win a set, but also by two clear games, so 6-4, 6-3 etc and if it goes to 6-6 we have to factor in a tie-break - wherein it is the first to 7 points again by a two point margin.

It would be good if there was an additional feature which could distinguish between a 3 set match and a 5 set match.

Thanks.

To be honest, this is rather involved. I'll take a look, if I have time, and of course someone else may jump in. Check back in a few hours.