Need Vba codes for the following

[Rajeev Muraleedharan]

i need vba codes for the below project. i have a list of 22 players from 2 teams like

A B C
Randy AUS BAT
Bryan NZ WK
John AUS BOWL
Daniel NZ ALL
Kannan AUS ALL
Shyam AUS BAT
Paul NZ BOWL


etc...

i need all possible combination of 11 members from this 22 members according to the below conditions.

the conditions are:
1. WK - minimum 1 and max 4 members
2. BAT - minimum 3 and max 6 members
3. ALL - minimum1 and max 4 members
4. BOWL - minimum 3 and max 6 members

Can anyone help on this?

 

[StephenCrump]

I have reproduced the sheet exactly as above, however the formula =AND((L5:O5>=L$1:O$1)*(L5:O5<=L$2:O$2)) returns #VAlue and not true or False. Is there something I haven't done right

Array-enter the formula, i.e. use CTRL-SHIFT-ENTER rather than ENTER.