% of wins, defeats and draws with specific player on the team

Hello everyone,

I'm organizing some data tables for a football tournment. Basically we have 10 players and every week we play 5 vs 5. The teams are drawn every week so eventually every player plays on the same team. At the end of the year the player with most points wins the competition. There are some things that I am trying to put on this tables, but i'm having some difficulties with some of them.

- Ratio of wins/defeats/draws that every player has with other player (when they play on the same team). Example: my % of wins when player 2 plays in my team;

- Number of games that each player has with specific player on the same team;

I allready have a tablet that includes all the players, the teams (Team A or Team B) where each one of them played in game 1, game 2, game 3 (and so on) ... and if the he won, draw or lost the games.

I tried using some IF AND functions, but i just can't get there :/

Could anyone give me a help with this questions please?


Thank you very much!

Hi and welcome.

Perhaps it would be easier to help if you could attach your workbook and show us your desired outcome.

BSB