Hi Alan

That no problem with 1 to 9.
X for tied just delete R9 to R26.
Yeah put If in if all grid cell empty.

Just to be clear if I got it right.
Once final game. Then you need to put a X grid if teams not Qualify for semi final?
or
You tell the team say JPN. you not Qualify for semi final and team don't want to carry on finish 1 to 3 game to finish group table. You want to put in X instead W or L? Rest of the JPN match in grid had play stay in W or L?
It that right?

Cheers