Find names & results in a list and tally them up

Bender1964

New Member
Joined
Aug 3, 2020
Messages
5
Office Version
  1. 2007
Platform
  1. Windows
Hi, first timer on this site. I run a local darts comp here in Australia, and 99% of what we do uses an Excel spreadsheet. We score on Excel, and also keep a running tally of the current seasons wins and losses by players to give us a ranked table. We have many seasons of data available in the form of an all seasons combined results table which lists the 2 players per games names side by side in columns and the points they scored in that game in the next 2 columns. What I would like to achieve is to sort through the table of results to produce a running total of wins and losses for each player against other particular players. This would allow us to know who has the best results against certain players etc.

I have attached a very small screenshot of our historical table. As per the attached table, the players names are in columns A & B, and the score for player 1 is in column C, and the score for player 2 is in column D. As an example, I would like to search through that table to find out how many times Dave Gibson has played Noel McCudden. This would give me a game total between the 2 players. I would then like to search through the sorted results to see how many times in these sorted games was Dave Gibson's score greater than 0 (greater than 0 is a win). This would then provide total games played between the 2 players, and a winning % for both of them against each other. I would then roll this out across all players.

Any help or suggestions are appreciated. I have been trying INDEX & MATCH, but I really don't understand it well enough. I have enough issues with VLOOKUP !!

Thanks Peter
 

Attachments

  • Table image for mr excel Aug 2020.jpg
    Table image for mr excel Aug 2020.jpg
    235 KB · Views: 27

ebea

Board Regular
Joined
Jul 12, 2008
Messages
206
Office Version
  1. 2010
Platform
  1. Windows
Hi Ebea, thanks again for your quick response. I really appreciate the time you have put into this. An example of what I need is as follows, using my data as the source:

Your spreadsheet shows Mick Hayward and Clark Joyce meeting 4 times. I would like to know the overall results of those 4 games. That is, how many has Mick won, and therefore how many Clark has won. The aim of this is to (a) have a career summary of all games won or lost (which your spreadsheet does really well) and (b) how each player has fared in games against each player.

I hope this makes sense.

Thanks Peter
I have updated the file, who already are Linked to, so you can download this. I added an extra Sheet, with the stats, including this with player to player!
 

Some videos you may like

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,493
Office Version
  1. 365
Platform
  1. Windows
but the Sheet was in a size, that I found it not to fit into the windows here in Forum.
Make a smaller example that still demonstrates the principle?

@Bender1964
Here is a macro approach if that interests you. I have assumed that data is in columns A:D and columns H:N can be used for the results (easy to change to another range or even another sheet).
Test with a copy of your workbook.

VBA Code:
Sub ResultSummary()
  Dim d As Object
  Dim a As Variant
  Dim sPlayers As String, tmp As String
  Dim i As Long, winner As Long

  Set d = CreateObject("Scripting.Dictionary")
  a = Range("A2", Range("D" & Rows.Count).End(xlUp)).Value
  For i = 1 To UBound(a)
    If Len(a(i, 1)) * Len(a(i, 2)) > 0 Then
      If a(i, 1) > a(i, 2) Then
        tmp = a(i, 1)
        a(i, 1) = a(i, 2)
        a(i, 2) = tmp
        tmp = a(i, 3)
        a(i, 3) = a(i, 4)
        a(i, 4) = tmp
      End If
      winner = IIf(a(i, 3) > 0, 1, 2)
      sPlayers = a(i, 1) & ";" & a(i, 2)
      If d.exists(sPlayers) Then
        If winner = 1 Then
          d(sPlayers) = ";;" & Split(d(sPlayers), ";")(2) + 1 & ";;" & Split(d(sPlayers), ";")(4)
        Else
          d(sPlayers) = ";;" & Split(d(sPlayers), ";")(2) & ";;" & Split(d(sPlayers), ";")(4) + 1
        End If
      Else
        d(sPlayers) = IIf(winner = 1, ";;1;;0", ";;0;;1")
      End If
    End If
  Next i
  Columns("H:N").Clear
  With Range("H2:I2").Resize(d.Count)
    .Value = Application.Transpose(Array(d.Keys, d.Items))
    .Columns(2).TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=False, Semicolon:=True, Comma:=False, Space:=False, Other:=False
    .Offset(, 2).Resize(, 1).FormulaR1C1 = "=RC[1]+RC[3]"
    With .Offset(, 4).Resize(, 1)
      .NumberFormat = "0.00%"
      .FormulaR1C1 = "=RC[-1]/RC[-2]"
    End With
    With .Offset(, 6).Resize(, 1)
      .NumberFormat = "0.00%"
      .FormulaR1C1 = "=RC[-1]/RC[-4]"
    End With
    .Columns(1).TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=False, Semicolon:=True, Comma:=False, Space:=False, Other:=False
    .Rows(0).Resize(, 7).Value = Array("Player 1", "Player 2", "Played", "P1 Wins", "P1 %", "P2 Wins", "P2 %")
  End With
  Columns("H:N").AutoFit
End Sub

Here is my small sample (data has been altered as well as reduced from your sample) and results of the code.

Bender1964 2020-08-05 1.xlsm
ABCDEFGHIJKLMNO
1ROUND 1 February 6 2019Player 1Player 2PlayedP1 WinsP1 %P2 WinsP2 %
2Mick HaywardClark Joyce013Clark JoyceMick Hayward4250.00%250.00%
3Ken SelwayCraig Malzard20Craig MalzardKen Selway3133.33%266.67%
4Craig MalzardDave Gibson870Craig MalzardDave Gibson4375.00%125.00%
5Peter HollinsManfred Sonntag028Manfred SonntagPeter Hollins3133.33%266.67%
6Dave GibsonNoel McCudden590Dave GibsonNoel McCudden2150.00%150.00%
7Clark JoyceKen Selway11100.00%00.00%
8ROUND 2 February 6 2019Noel McCuddenPeter Hollins100.00%1100.00%
9Clark JoyceMick Hayward016Alan TaylorManfred Sonntag100.00%1100.00%
10Clark JoyceKen Selway410Mick HaywardNoel McCudden100.00%1100.00%
11Peter HollinsNoel McCudden1330Chris FinchKen Selway11100.00%00.00%
12Manfred SonntagAlan Taylor340Chris FinchClark Joyce100.00%1100.00%
13Alan TaylorPeter Hollins11100.00%00.00%
14ROUND 3 February 13 2019
15Mick HaywardClark Joyce400
16Ken SelwayCraig Malzard0129
17Craig MalzardDave Gibson070
18Peter HollinsManfred Sonntag270
19Dave GibsonNoel McCudden013
20
21ROUND 4 February 13 2019
22Craig MalzardDave Gibson60
23Noel McCuddenMick Hayward380
24Chris FinchKen Selway20
25Clark JoyceChris Finch940
26Alan TaylorPeter Hollins160
27
28ROUND 5 February 20 2019
29Mick HaywardClark Joyce018
30Ken SelwayCraig Malzard2100
31Craig MalzardDave Gibson360
32Peter HollinsManfred Sonntag280
33Dave GibsonNoel McCudden
34
Sheet1
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,493
Office Version
  1. 365
Platform
  1. Windows
Adding a sort on names might be beneficial? Add the blue line where shown

Rich (BB code):
    .Columns(1).TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=False, Semicolon:=True, Comma:=False, Space:=False, Other:=False
    .Rows(0).Resize(, 7).Value = Array("Player 1", "Player 2", "Played", "P1 Wins", "P1 %", "P2 Wins", "P2 %")
    .Resize(, 7).Sort Key1:=.Columns(1), Order1:=xlAscending, Key2:=.Columns(2), Order2:=xlAscending, Header:=xlNo
  End With
  Columns("H:N").AutoFit

Results on same data:

Bender1964 2020-08-05 1.xlsm
HIJKLMNO
1Player 1Player 2PlayedP1 WinsP1 %P2 WinsP2 %
2Alan TaylorManfred Sonntag100.00%1100.00%
3Alan TaylorPeter Hollins11100.00%00.00%
4Chris FinchClark Joyce100.00%1100.00%
5Chris FinchKen Selway11100.00%00.00%
6Clark JoyceKen Selway11100.00%00.00%
7Clark JoyceMick Hayward4250.00%250.00%
8Craig MalzardDave Gibson4375.00%125.00%
9Craig MalzardKen Selway3133.33%266.67%
10Dave GibsonNoel McCudden2150.00%150.00%
11Manfred SonntagPeter Hollins3133.33%266.67%
12Mick HaywardNoel McCudden100.00%1100.00%
13Noel McCuddenPeter Hollins100.00%1100.00%
14
Sheet1
 

Bender1964

New Member
Joined
Aug 3, 2020
Messages
5
Office Version
  1. 2007
Platform
  1. Windows
Hi Ebea & Peter, thanks again for your input. Peter, I have done as requested and pasted a small data sample below which has the functionality Ebea provided with a manually created table below his table. It is this manually created table that I would love to automate, as we have hundreds of games in our database built up over years. Your help is appreciated. And Peter, I'm happy to work with macros as we have them in our scoring spreadsheet to clear cells and change names etc. Thanks Peter

Mr Excel darts all time games ranking spreadsheet.xlsx
ABCDEFGHIJKLMNO
1ROUND 1Home scoreAway scoreMet number of timesWinner / Loser X are winnerPlayersPlayed number of timesWonLostPercent WonRank
2Player 1Player 60132 XPlayer 1105550.00%3
3Player 2Player 5202X Player 2105550.00%3
4Player 3Player 48702X Player 3101910.00%6
5  Player 4105550.00%3
6ROUND 2  Player 5107370.00%1
7Player 1Player 20162 XPlayer 6107370.00%1
8Player 5Player 34102X 
9Player 6Player 413302X 
10  
11ROUND 3  The table below is what I would love to have done automatically
12Player 2Player 64002X Results vs each playerPlayedWonLost% won
13Player 3Player 101292 X
14Player 4Player 50702 XPlayer 1vsPlayer 221150.00%
15  Player 3220100.00%
16ROUND 4  Player 421150.00%
17Player 6Player 5602X Player 521150.00%
18Player 1Player 43802X Player 62020.00%
19Player 2Player 3202X 
20  
21ROUND 5  
22Player 3Player 60182 X
23Player 4Player 221002X 
24Player 5Player 13602X 
25  
26ROUND 6  
27Player 1Player 60132 X
28Player 2Player 501212 X
29Player 3Player 40592 X
30  
31ROUND 7  
32Player 1Player 22802X 
33Player 5Player 34102X 
34Player 6Player 40542 X
35  
36ROUND 8  
37Player 2Player 60402 X
38Player 3Player 10222 X
39Player 4Player 50702 X
40  
41ROUND 9  
42Player 6Player 50122 X
43Player 1Player 40452 X
44Player 2Player 32202X 
45  
46ROUND 10  
47Player 3Player 60262 X
48Player 4Player 211502X 
49Player 5Player 10362 X
Ark1
Cell Formulas
RangeFormula
F2:G49F2=IF(C2>0,"X","")
J2:J7J2=COUNTIF($A$2:$B$49,I2)
K2:K7K2=SUMPRODUCT(($A$2:$B$49=$I2)*($F$2:$G$49="X"))
N14:N18,L2:L7L2=J2-K2
O14:O18,M2:M7M2=K2/J2
N2:N7N2=RANK(M2,$M$2:$M$12)
E47:E49,E42:E44,E37:E39,E32:E34,E27:E29,E22:E24,E17:E19,E12:E14,E7:E9,E2:E4E2=SUMPRODUCT(($A$2:$A$49=A2)*($B$2:$B$49=B2)+($A$2:$A$49=B2)*($B$2:$B$49=A2))
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,493
Office Version
  1. 365
Platform
  1. Windows

ADVERTISEMENT

.. a manually created table below his table. It is this manually created table that I would love to automate,
I just ran my code on the data from post 14. Doesn't the green area contain all the information in your manually created table (+ bit more which could be removed if required)?

Bender1964 2020-08-05 1.xlsm
ABCDHIJKLMN
1ROUND 1Home scoreAway scorePlayer 1Player 2PlayedP1 WinsP1 %P2 WinsP2 %
2Player 1Player 6013Player 1Player 22150.00%150.00%
3Player 2Player 520Player 1Player 322100.00%00.00%
4Player 3Player 4870Player 1Player 42150.00%150.00%
5Player 1Player 52150.00%150.00%
6ROUND 2Player 1Player 6200.00%2100.00%
7Player 1Player 2016Player 2Player 322100.00%00.00%
8Player 5Player 3410Player 2Player 4200.00%2100.00%
9Player 6Player 41330Player 2Player 52150.00%150.00%
10Player 2Player 62150.00%150.00%
11ROUND 3Player 3Player 42150.00%150.00%
12Player 2Player 6400Player 3Player 5200.00%2100.00%
13Player 3Player 10129Player 3Player 6200.00%2100.00%
14Player 4Player 5070Player 4Player 5200.00%2100.00%
15Player 4Player 62150.00%150.00%
16ROUND 4Player 5Player 62150.00%150.00%
17Player 6Player 560
18Player 1Player 4380
19Player 2Player 320
20
21ROUND 5
22Player 3Player 6018
23Player 4Player 22100
24Player 5Player 1360
25
26ROUND 6
27Player 1Player 6013
28Player 2Player 50121
29Player 3Player 4059
30
31ROUND 7
32Player 1Player 2280
33Player 5Player 3410
34Player 6Player 4054
35
36ROUND 8
37Player 2Player 6040
38Player 3Player 1022
39Player 4Player 5070
40
41ROUND 9
42Player 6Player 5012
43Player 1Player 4045
44Player 2Player 3220
45
46ROUND 10
47Player 3Player 6026
48Player 4Player 21150
49Player 5Player 1036
Sheet2 (2)
 

ebea

Board Regular
Joined
Jul 12, 2008
Messages
206
Office Version
  1. 2010
Platform
  1. Windows
Hi Ebea & Peter, thanks again for your input. Peter, I have done as requested and pasted a small data sample below which has the functionality Ebea provided with a manually created table below his table. It is this manually created table that I would love to automate, as we have hundreds of games in our database built up over years. Your help is appreciated. And Peter, I'm happy to work with macros as we have them in our scoring spreadsheet to clear cells and change names etc. Thanks Peter

Mr Excel darts all time games ranking spreadsheet.xlsx
ABCDEFGHIJKLMNO
1ROUND 1Home scoreAway scoreMet number of timesWinner / Loser X are winnerPlayersPlayed number of timesWonLostPercent WonRank
2Player 1Player 60132 XPlayer 1105550.00%3
3Player 2Player 5202X Player 2105550.00%3
4Player 3Player 48702X Player 3101910.00%6
5  Player 4105550.00%3
6ROUND 2  Player 5107370.00%1
7Player 1Player 20162 XPlayer 6107370.00%1
8Player 5Player 34102X 
9Player 6Player 413302X 
10  
11ROUND 3  The table below is what I would love to have done automatically
12Player 2Player 64002X Results vs each playerPlayedWonLost% won
13Player 3Player 101292 X
14Player 4Player 50702 XPlayer 1vsPlayer 221150.00%
15  Player 3220100.00%
16ROUND 4  Player 421150.00%
17Player 6Player 5602X Player 521150.00%
18Player 1Player 43802X Player 62020.00%
19Player 2Player 3202X 
20  
21ROUND 5  
22Player 3Player 60182 X
23Player 4Player 221002X 
24Player 5Player 13602X 
25  
26ROUND 6  
27Player 1Player 60132 X
28Player 2Player 501212 X
29Player 3Player 40592 X
30  
31ROUND 7  
32Player 1Player 22802X 
33Player 5Player 34102X 
34Player 6Player 40542 X
35  
36ROUND 8  
37Player 2Player 60402 X
38Player 3Player 10222 X
39Player 4Player 50702 X
40  
41ROUND 9  
42Player 6Player 50122 X
43Player 1Player 40452 X
44Player 2Player 32202X 
45  
46ROUND 10  
47Player 3Player 60262 X
48Player 4Player 211502X 
49Player 5Player 10362 X
Ark1
Cell Formulas
RangeFormula
F2:G49F2=IF(C2>0,"X","")
J2:J7J2=COUNTIF($A$2:$B$49,I2)
K2:K7K2=SUMPRODUCT(($A$2:$B$49=$I2)*($F$2:$G$49="X"))
N14:N18,L2:L7L2=J2-K2
O14:O18,M2:M7M2=K2/J2
N2:N7N2=RANK(M2,$M$2:$M$12)
E47:E49,E42:E44,E37:E39,E32:E34,E27:E29,E22:E24,E17:E19,E12:E14,E7:E9,E2:E4E2=SUMPRODUCT(($A$2:$A$49=A2)*($B$2:$B$49=B2)+($A$2:$A$49=B2)*($B$2:$B$49=A2))
I have, as I wrote in #11 updated the file I uploaded previous, so you can redownload that again. It has the function you ask for.
PS: I was thinking on, after a look in all players numbers of times played, that there are a big difference in these. Is this conscious, or because you missing a way to control if all has played against each other, exact number of times . A Robin tournament list, can do the trick. I have such a schedule plan, made in Excel.
 
Last edited:

ebea

Board Regular
Joined
Jul 12, 2008
Messages
206
Office Version
  1. 2010
Platform
  1. Windows

ADVERTISEMENT

Make a smaller example that still demonstrates the principle?

@Bender1964
Here is a macro approach if that interests you. I have assumed that data is in columns A:D and columns H:N can be used for the results (easy to change to another range or even another sheet).
Test with a copy of your workbook.

VBA Code:
Sub ResultSummary()
  Dim d As Object
  Dim a As Variant
  Dim sPlayers As String, tmp As String
  Dim i As Long, winner As Long

  Set d = CreateObject("Scripting.Dictionary")
  a = Range("A2", Range("D" & Rows.Count).End(xlUp)).Value
  For i = 1 To UBound(a)
    If Len(a(i, 1)) * Len(a(i, 2)) > 0 Then
      If a(i, 1) > a(i, 2) Then
        tmp = a(i, 1)
        a(i, 1) = a(i, 2)
        a(i, 2) = tmp
        tmp = a(i, 3)
        a(i, 3) = a(i, 4)
        a(i, 4) = tmp
      End If
      winner = IIf(a(i, 3) > 0, 1, 2)
      sPlayers = a(i, 1) & ";" & a(i, 2)
      If d.exists(sPlayers) Then
        If winner = 1 Then
          d(sPlayers) = ";;" & Split(d(sPlayers), ";")(2) + 1 & ";;" & Split(d(sPlayers), ";")(4)
        Else
          d(sPlayers) = ";;" & Split(d(sPlayers), ";")(2) & ";;" & Split(d(sPlayers), ";")(4) + 1
        End If
      Else
        d(sPlayers) = IIf(winner = 1, ";;1;;0", ";;0;;1")
      End If
    End If
  Next i
  Columns("H:N").Clear
  With Range("H2:I2").Resize(d.Count)
    .Value = Application.Transpose(Array(d.Keys, d.Items))
    .Columns(2).TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=False, Semicolon:=True, Comma:=False, Space:=False, Other:=False
    .Offset(, 2).Resize(, 1).FormulaR1C1 = "=RC[1]+RC[3]"
    With .Offset(, 4).Resize(, 1)
      .NumberFormat = "0.00%"
      .FormulaR1C1 = "=RC[-1]/RC[-2]"
    End With
    With .Offset(, 6).Resize(, 1)
      .NumberFormat = "0.00%"
      .FormulaR1C1 = "=RC[-1]/RC[-4]"
    End With
    .Columns(1).TextToColumns DataType:=xlDelimited, ConsecutiveDelimiter:=False, Semicolon:=True, Comma:=False, Space:=False, Other:=False
    .Rows(0).Resize(, 7).Value = Array("Player 1", "Player 2", "Played", "P1 Wins", "P1 %", "P2 Wins", "P2 %")
  End With
  Columns("H:N").AutoFit
End Sub

Here is my small sample (data has been altered as well as reduced from your sample) and results of the code.

Bender1964 2020-08-05 1.xlsm
ABCDEFGHIJKLMNO
1ROUND 1 February 6 2019Player 1Player 2PlayedP1 WinsP1 %P2 WinsP2 %
2Mick HaywardClark Joyce013Clark JoyceMick Hayward4250.00%250.00%
3Ken SelwayCraig Malzard20Craig MalzardKen Selway3133.33%266.67%
4Craig MalzardDave Gibson870Craig MalzardDave Gibson4375.00%125.00%
5Peter HollinsManfred Sonntag028Manfred SonntagPeter Hollins3133.33%266.67%
6Dave GibsonNoel McCudden590Dave GibsonNoel McCudden2150.00%150.00%
7Clark JoyceKen Selway11100.00%00.00%
8ROUND 2 February 6 2019Noel McCuddenPeter Hollins100.00%1100.00%
9Clark JoyceMick Hayward016Alan TaylorManfred Sonntag100.00%1100.00%
10Clark JoyceKen Selway410Mick HaywardNoel McCudden100.00%1100.00%
11Peter HollinsNoel McCudden1330Chris FinchKen Selway11100.00%00.00%
12Manfred SonntagAlan Taylor340Chris FinchClark Joyce100.00%1100.00%
13Alan TaylorPeter Hollins11100.00%00.00%
14ROUND 3 February 13 2019
15Mick HaywardClark Joyce400
16Ken SelwayCraig Malzard0129
17Craig MalzardDave Gibson070
18Peter HollinsManfred Sonntag270
19Dave GibsonNoel McCudden013
20
21ROUND 4 February 13 2019
22Craig MalzardDave Gibson60
23Noel McCuddenMick Hayward380
24Chris FinchKen Selway20
25Clark JoyceChris Finch940
26Alan TaylorPeter Hollins160
27
28ROUND 5 February 20 2019
29Mick HaywardClark Joyce018
30Ken SelwayCraig Malzard2100
31Craig MalzardDave Gibson360
32Peter HollinsManfred Sonntag280
33Dave GibsonNoel McCudden
34
Sheet1
I did try you'r code Peter; but something is not correct in this! You can even see it in you'r own example. There are missing names in the list, which already start on the 2. section of the name list (Column A - Clark Joyce - Mick Hayward). And so it continue the whole list. A lot of names are missing!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,493
Office Version
  1. 365
Platform
  1. Windows
You can even see it in you'r own example. There are missing names in the list
Sorry, I am not following. I assume you are referring to posts 12 &/or 13? In my sample data in columns A:D in post 12 I have 23 game results. In column J the total games played is 23.

Are you saying that there are names in columns A:B that do not appear in columns H:I? If so can you specify 1 or 2 as they all appear to me to be there?
If that is not what you meant can you explain a different way & give specific example(s)?
 

ebea

Board Regular
Joined
Jul 12, 2008
Messages
206
Office Version
  1. 2010
Platform
  1. Windows
Sorry, I am not following. I assume you are referring to posts 12 &/or 13? In my sample data in columns A:D in post 12 I have 23 game results. In column J the total games played is 23.

Are you saying that there are names in columns A:B that do not appear in columns H:I? If so can you specify 1 or 2 as they all appear to me to be there?
If that is not what you meant can you explain a different way & give specific example(s)?
If you, by example, takes the list from #4, and put into Excel, and run you'r code, then you will see, that the name list the code generate in Column H:I do missing names. It start already in the second section in Column A (Row 9 in you'r examples), and the longer the list becomes, the more names are missing.
The number of times each other met, are correct, but not the name list.

You can actually also see it in you'r code example in #12.
Another"strange" thing is, that the name change position in the generated list, which in case of playing two different places, can have a meaning!
 

Peter_SSs

MrExcel MVP, Moderator
Joined
May 28, 2005
Messages
47,493
Office Version
  1. 365
Platform
  1. Windows
Perhaps we are expecting different things.

If you, by example, takes the list from #4, and put into Excel, and run you'r code, then you will see, that the name list the code generate in Column H:I do missing names.
I don't see that at all. That is, unless you mean, say Ian Hollins who is listed in column F of post 4 but not in the results of my code. That is because Ian Hollins has not played any games - does not appear in columns A:B either.

It start already in the second section in Column A (Row 9 in you'r examples)
Again I do not understand what you are saying. Column A row 9 in my examples is Clark Joyce. In columns A:B in post 12 Clark Joyce appears a total of 6 times playing against 3 different people: Mick Hayward, Ken Selway and Chris Finch.
Clark Joyce is shown in the results in that post in rows 2, 7 and 12 in columns H:I where his 6 results against those 3 opponents are summarised by number played, number won & % won. So I still fail to see anything missing.

Bender1964 2020-08-05 1.xlsm
ABCDEFGHIJKLMN
1ROUND 1 February 6 2019P1P2PlayedP1 winsP1 %P2 winsP2 %
2Mick HaywardClark Joyce013Clark JoyceMick Hayward4250.00%250.00%
3Ken SelwayCraig Malzard20Craig MalzardKen Selway3133.33%266.67%
4Craig MalzardDave Gibson870Craig MalzardDave Gibson4375.00%125.00%
5Peter HollinsManfred Sonntag028Manfred SonntagPeter Hollins3133.33%266.67%
6Dave GibsonNoel McCudden590Dave GibsonNoel McCudden2150.00%150.00%
7Clark JoyceKen Selway11100.00%00.00%
8ROUND 2 February 6 2019Noel McCuddenPeter Hollins100.00%1100.00%
9Clark JoyceMick Hayward016Alan TaylorManfred Sonntag100.00%1100.00%
10Clark JoyceKen Selway410Mick HaywardNoel McCudden100.00%1100.00%
11Peter HollinsNoel McCudden1330Chris FinchKen Selway11100.00%00.00%
12Manfred SonntagAlan Taylor340Chris FinchClark Joyce100.00%1100.00%
13Alan TaylorPeter Hollins11100.00%00.00%
14ROUND 3 February 13 2019
15Mick HaywardClark Joyce400
16Ken SelwayCraig Malzard0129
17Craig MalzardDave Gibson070
18Peter HollinsManfred Sonntag270
19Dave GibsonNoel McCudden013
20
21ROUND 4 February 13 2019
22Craig MalzardDave Gibson60
23Noel McCuddenMick Hayward380
24Chris FinchKen Selway20
25Clark JoyceChris Finch940
26Alan TaylorPeter Hollins160
27
28ROUND 5 February 20 2019
29Mick HaywardClark Joyce018
30Ken SelwayCraig Malzard2100
31Craig MalzardDave Gibson360
32Peter HollinsManfred Sonntag280
33Dave GibsonNoel McCudden
Sheet1
Cell Formulas
RangeFormula
J2:J13J2=K2+M2
L2:L13L2=K2/J2
N2:N13N2=M2/J2
 

Watch MrExcel Video

Forum statistics

Threads
1,118,707
Messages
5,573,725
Members
412,549
Latest member
ThomDubya
Top