Help with formula for league table!

Hello everyone

I wonder if anyone with more knowledge than I can assist here. We currently run a sports league and keep a record of winners and losers in the following way.

Name Week 1 Week 2 Week 3 Week 4 Week 5 Week 6
Person 1 W W W W W W
Person 2 W L L W L L
Person 3 W W W W W W
Person 4 L L L L L W
Person 5 L W L L L W
Person 6 L L W L W L

By doing this, I can easily create a formula of winning percentages. Person 3 = 100% etc.

However, how would I go about creating a column which showed the highest to lowest 'combinations' of people.

So, to try and explain, in this case person 1 and person 3 would have 100%, as they have been on the same winning 'W' side every week.

Any help greatly appreciated. I can clarify if needed as it's a bit hard to explain.

The attached sheet works out the highest pairing. All of the work is done on sheet 2, except for the simple lookup to display the highest pair on sheet 1.

It does have a number of issues, mostly around tied results and I suspect that there are a host of issues if you try to, say, find the second highest scoring pair.

Still, this might get you started.