Sprogget,
he's creating the = to denote teams who are jointly sharing a position in a league table, so by definition, they would be next to each other in the rows.
As Hugh enters the weekly scores in columns B-X each team's total score will change and hence their ranking on the leader board. There is no guarantee that they will be in the correct order unless the table is resorted each week on the values in column Y. For your statement to be correct you have to assume that that step will be taken, which was not given in the original brief in post 1.
I have written a solution which works for the original brief and does not assume any action not explicitly stated. I raise this not as a criticism, but as a learning point as it is a neat illustration of how software projects go wrong.
HTH
EG