Build an fantasy sports team combination generator

[Rahulbranta]

Hi, suppose there are 2 cricket teams each team have 11 players. So total 22 players. I want to create a sheet where I can just change the player names and maximum numbers of combination can be generated automatically. There are few conditions like to create a team of 11 players we can only select maximum 7 players from a single team. And for each team we get 100 credits. And these credits for each team player is different like some player is of 9 credits some of 8, 10. 8 is minimum. So what I want is a sheet where 22 players will be available and in from of them their credits will be written then it should generate max combination.

 

[BSALV]

is this the same question and what was wrong with the answer ???

macro req

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 team by picking 11 players as per the following combinations (C1,C2,C3...) within a budget of 100 credits. Step...

www.mrexcel.com

 

[Joe4]

is this the same question and what was wrong with the answer ???

Its does not appear to be the same user.
You can see this user joined today and this is the user's first post.

 

[BSALV]

Its does not appear to be the same user.

You're right about that !
When you read this question, she is less detailed then the other but in essence the same.
So before answering to this question, would the answer to the other post also be an answer to this post ?
If not, where have i to make modifications ? What answer do you expect ?