Hi all,
I am trying to put together a solution to total the all time result between all unique player combinations. I have provided examples of my data in the first table below, and what I'm trying to accomplish in the second table. First row is column letters, so the second row is actually Row 1.
You can see in the Daily Results that there are 6 matches, but only 3 unique combinations of players. You'll also see that sometimes, say, when Jane plays Ben, that Ben will be listed first, while other times, Jane will be listed first. This can't be helped, and needs to stay this way, but for the purpose of creating All Time Results, the order of players is irrelevant, and should be considered the same unique match up, i.e. Ben vs Jane = Jane vs Ben. I don't care which of the two players is listed in column G in the All Time Results
Anyone care to take a stab at this, or hold my hand a lot?
Thank you!
I am trying to put together a solution to total the all time result between all unique player combinations. I have provided examples of my data in the first table below, and what I'm trying to accomplish in the second table. First row is column letters, so the second row is actually Row 1.
You can see in the Daily Results that there are 6 matches, but only 3 unique combinations of players. You'll also see that sometimes, say, when Jane plays Ben, that Ben will be listed first, while other times, Jane will be listed first. This can't be helped, and needs to stay this way, but for the purpose of creating All Time Results, the order of players is irrelevant, and should be considered the same unique match up, i.e. Ben vs Jane = Jane vs Ben. I don't care which of the two players is listed in column G in the All Time Results
Anyone care to take a stab at this, or hold my hand a lot?
Thank you!
Last edited by a moderator:
