Combinations and permutations

[Sathishrgboys]

I have some work, in an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team.
The conditions are as below :-
Create your Dream11 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget of 100 credits.
Step 2: Create your Team
Select players for your Dream11 team from all 4 of the categories mentioned below:
WK - Wicket-keeper (1)
BAT - Batsmen( min 3 & max 5)
BWL - Bowlers( min 3 & max 5)
AR - All-rounders( min 1 & max 3)
So there are 7 combinations for the team which could be created.
Once all the combinations are created.. we need to check which teams credits sum to 100 credits.
The input will be 22 players and the credits required and the points earned so far.
After that from the shortlisted teams create an combinations of Captain & vice captain for each team. This will be separate sheet where I will enter the 11 players team. The combinations of Captain and vice Captain should output in next excel

 

[patelchirag0009]

you done work then u upload file

 

[Badri0011]

Hi, This is regarding Dream11

How to create multiple teams with 22 people combinations and we should create 11 people as a team (Every team should have min 4 people and max 7 people) please create max teams