Team Generation

[Suresh K R]

In an Excel spreadsheet. Create an excel where there are 22 players list and create all the possible combinations for 11 players team.
Create a team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget of 100 credits.

Select players for a team from all 4 of the categories mentioned below:
WK - Wicket-keeper (min 1 & max 3)
BAT - Batsmen( min 3 & max 6)
BWL - Bowlers( min 3 & max 6)
AR - All-rounders( min 1 & max 4)

[Pepe Le Mokko]

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

[Suresh K R]

My Post has edited with attachment