Hello All,

Thanks for having this wonderful forum and I request your help with a small challenge of mine. I am new to excel and not sure if excel can do this at all, but I give it a try.

We have a small team of players(around 30) out of which around 20 who come every week to play soccer. The team is made by splitting those who came for the came on ground to try to make two equal teams. From the data collected, I am trying to figure out if a combination of players( 2/3/4) when in one team has a better chance of winning. With 'countif' I can see who win the most, but not which team can have more wins.

Put it simply does the team have more wins if Frank & Anthony play on one side or if Jacob,Kim and Nir plays on one side. WIN in the sheet below means the the player was in the winning team and LOST vice versa.

Thanks very much and I am curious to know if this data or additional data can show some insights.

Thanks for having this wonderful forum and I request your help with a small challenge of mine. I am new to excel and not sure if excel can do this at all, but I give it a try.

We have a small team of players(around 30) out of which around 20 who come every week to play soccer. The team is made by splitting those who came for the came on ground to try to make two equal teams. From the data collected, I am trying to figure out if a combination of players( 2/3/4) when in one team has a better chance of winning. With 'countif' I can see who win the most, but not which team can have more wins.

Put it simply does the team have more wins if Frank & Anthony play on one side or if Jacob,Kim and Nir plays on one side. WIN in the sheet below means the the player was in the winning team and LOST vice versa.

NAME | Wins | Loss | Game 1 | Game 2 | Game 3 | Game 4 | Game 5 |

Frank | 2 | 3 | WIN | WIN | LOST | Lost | LOST |

Anthony | 2 | 3 | Lost | WIN | LOST | Win | LOST |

Thomas | 3 | 2 | Win | WIN | WIN | Lost | LOST |

Jacob | 3 | 2 | Lost | WIN | WIN | Win | LOST |

Shib | 2 | 3 | Win | WIN | LOST | Lost | LOST |

Marod | 2 | 3 | Lost | LOST | LOST | Win | WIN |

Ire | 2 | 3 | Win | LOST | LOST | Lost | WIN |

Jim | 3 | 2 | Lost | LOST | WIN | Win | WIN |

Nir | 3 | 2 | Win | LOST | WIN | Lost | WIN |

Kim | 3 | 2 | Lost | LOST | WIN | Win | WIN |

Thanks very much and I am curious to know if this data or additional data can show some insights.

Last edited by a moderator: