Hi,

Iam looking for a excel sheet where we can create possible combinations to create a team automatically with the following conditions:

1.0) Need to create 8 players to form a team
2.0) Can select minimum of 3 & maximum of 5 players from one team at a time - to generate 8 players combo team.
3.0) Each player will come with some credits & total count for 8 player team combination should be max 100, Example of credits as below
Team A Team B
Player A1 : 19.5 Player B1 : 9.5
Player A2 : 13 Player B2 : 14
Player A3 : 11 Player B3 : 6.5
Player A4 : 7.5 Player B4 : 16.5
Player A5 : 11.5 Player B5 : 5.5
Player A6 : 17 Player B6 : 6.5
Player A7 : 8.5 Player B7 : 27
Player B8 : 12.5

Please help!!!!


Jay