Huge Permutation Problem
Hello. Please could I have some advice to help solve a problem which has an extraordinary amount of permutations. I feel like I have got lost in the numbers somewhat and could be missing a relatively simple way to solve the problem.
I have a simple sheet that records 100 bets and each bets potential winnings.
Each bet involves 4 teams, one from each of 4 leagues (entitled League 1, League 2, League 3, League 4).
For a bet to be successful ALL 4 TEAMS MUST WIN. If any of the 4 teams does not win the return from that bet is £0.
There will only be 3 winning teams from League 1,
3 winning teams from League 2,
3 winning teams from League 3,
4 winning teams from League 4.
This makes 13 winning teams in total.
However 12 different teams have been selected from League A,
16 selected from League B,
15 selected from League C,
17 selected from League D.
My question is what combination of 13 teams would give me the maximum return?
Remember only 3 teams will win from Leagues A,B+C and 4 teams from League D.
Not sure I have explained it absolutely clearly but I have added a photo of the spreadsheet.
http://www.mrexcel.com/forum/
http://www.mrexcel.com/forum/excel-questions/873910-huge-permutation-pro...