Combinations with Limitations.

[santa35473]

So I have a really tough issue that I can't seem to wrap my head around. I have a list of players in each position QB, RB, WR, and TE. I need to pick 1 QB, 2 RBs, 3 WRs, and 1 TE from these lists, I would assume by using combinations. On top of this I want to be able to then limit the combinations I made based on a salary cap of 51,500 (I have assigned values for each of the players). So basically I have a list of players, their values, and know how many of each position I need, and what my total "salary" has to be under. I want to know every possible combination that I could have that would stay under that cap of 51,500. This seems like such an enormous challenge and I would love some wisdom from the experts on here about how to attack it! Thanks in advance!

 

[sheetspread]

Post #8 is applicable here:

http://www.mrexcel.com/forum/lounge-v-2-0/856840-how-many-combinations.html