Help to automate ranking of tied teams in sports scoring program

Hi Alan

Thank for file. It won't make any different whether 1 vs 0 will work cos it still 5 teams on 4.
Still have problem as we got now.

I come up with idea.

When the final Rank come up.
If no X come up mean spot on final rank
If X come up n S9 to S26. Then you need to double check whether final rank is spot on or not.

If not spot on. R column you just put in a 1 that will change to correct Final Rank.

This is only way it will work with a W or L.
Unless the score need put in.

Have a look at v8 workbook?

Cheers