I have 10 teams playing one game in sets of two for a total of 5 games only. I have oragnized an example of what I want but I have done it by hand. There are 5 home teams and 5 away teams. Each team and their opponent is set and can not change. I need an excel formula to determine the possible outcomes for each game. The formula could be hilighting the winning team or the losing team, it could be answering winner or loser in the colum next to the teams. I just need a way to make this process faster than by entering by hand. Attached is a excel sheet that shows more of what I am trying to do for clairity. I only did the most basic selection by hand but need a way to determine every possible win/loss sequence/variation in excel or other formula. (No data in row 22, just skiped it so I can fit in all sets that I made.)
I have 10 teams playing one game in sets of two for a total of 5 games only.
I have oragnized an example of what I want but I have done it by hand. There are 5 home teams and 5 away teams. Each team and their opponent is set and can not change. I need an excel formula to determine the possible outcomes for each game. The formula could be hilighting the winning team or the losing team, it could be answering winner or loser in the colum next to the teams. I just need a way to make this process faster than by entering by hand. Attached is a excel sheet that shows more of what I am trying to do for clairity.
I only did the most basic selection by hand but need a way to determine every possible win/loss sequence/variation in excel or other formula. (No data in row 22, just skiped it so I can fit in all sets that I made.)
![23 Fruit
24 Apple
Win
25 Orange
Loss
26 Grape
Win
27 Bananna Win
28 Strawberrie Win
29
30 Fruit
31 Apple
32 Orange
Win
Win
33 Grape
Loss
34 Bananna Win
35 Strawberrie Win
36
37 Fruit
38 Apple
Win
39 Orange
Win
40 Grape
Win
41 Bananna Loss
42 Strawberrie Win
43
44 Fruit
45 Apple
Win
46 Orange Win
47 Grape
Win
48 Bananna Win
49 Strawberrie Loss
Vegetable
Kale
Loss
Carrot
Win
Bean
Loss
Lettice Loss
Squash Loss
Vegetable
Kale
Carrot
Bean
Lettice
Squash
Loss
Loss
Win
Loss
Loss
Vegetable
Kale
Loss
Carrot Loss
Bean
Loss
Lettice Win
Squash
Loss
Vegetable
Kale
Loss
Carrot Loss
Bean
Loss
Lettice Loss
Squash Win
Fruit
Apple Loss
Orange Win
Grape
Loss
Bananna Loss
Strawberri Loss
Fruit
Apple
Loss
Orange Loss
Grape Win
Bananna Loss
Strawberri Loss
Fruit
Apple Loss
Orange Loss
Grape
Loss
Bananna Win
Strawberri Loss
Fruit
Apple Loss
Orange Loss
Grape
Loss
Bananna Loss
Strawberri Win
Vegetable
Kale
Win
Carrot
Loss
Bean
Win
Lettice
Win
Squash Win
Vegetable
Kale
Win
Carrot
Win
Bean
Loss
Lettice Win
Squash Win
Vegetable
Kale
Carrot
Bean
Lettice
Loss
Squash Win
Win
Win
Win
Vegetable
Kale
Win
Carrot
Win
Bean
Win
Lettice
Win
Squash Loss](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9b1d98cf-a768-4464-b954-6506c05fcae4%2Fb1fd6591-92d0-49fa-971d-3a9b8c5c42c9%2F4joof3_processed.png&w=3840&q=75)
![1
Fruit
2 Apple
3 Orange
4 Grape
5 Bananna
6 Strawberrie
7
8
9 Fruit
10 Apple
Win
11 Orange
Win
12 Grape
Win
13 Bananna Win
14 Strawberrie Win
15
16 Fruit
17 Apple
Loss
18 Orange
Win
19 Grape
Win
20 Bananna Win
21 Strawberrie Win
5
Vegetable
Kale
Carrot
Bean
Lettice
Squash
5
Vegetable
Kale
Loss
Carrot
Loss
Bean
Loss
Lettice
Loss
Squash Loss
Vegetable
Kale
Carrot
Bean
Lettice
Squash
Win
Loss
Loss
Loss
Loss
Fruit
Apple
Loss
Orange
Loss
Grape
Loss
Bananna Loss
Strawberri Loss
Fruit
Apple
Win
Orange Loss
Grape
Loss
Bananna Loss
Strawberri Loss
Vegetable
Kale
Win
Carrot
Win
Bean
Win
Lettice Win
Squash Win
Vegetable
Kale
Loss
Carrot
Win
Bean
Win
Lettice Win
Squash Win](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9b1d98cf-a768-4464-b954-6506c05fcae4%2Fb1fd6591-92d0-49fa-971d-3a9b8c5c42c9%2F43wctsk_processed.png&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 5 steps with 4 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![MATLAB: An Introduction with Applications](https://www.bartleby.com/isbn_cover_images/9781119256830/9781119256830_smallCoverImage.gif)
![Probability and Statistics for Engineering and th…](https://www.bartleby.com/isbn_cover_images/9781305251809/9781305251809_smallCoverImage.gif)
![Statistics for The Behavioral Sciences (MindTap C…](https://www.bartleby.com/isbn_cover_images/9781305504912/9781305504912_smallCoverImage.gif)
![Elementary Statistics: Picturing the World (7th E…](https://www.bartleby.com/isbn_cover_images/9780134683416/9780134683416_smallCoverImage.gif)
![The Basic Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319042578/9781319042578_smallCoverImage.gif)
![Introduction to the Practice of Statistics](https://www.bartleby.com/isbn_cover_images/9781319013387/9781319013387_smallCoverImage.gif)