I play fantasy sports and need help. I need for excel solver to figure a lineup for me based on the salary of the players. For example I need to find all possible combinations of teams that I can play that their value is within the salary limit range. The league I play in has 1 QB, 2 RB, 3WR, 1TE, 1Kicker, 1Def. I will list the players that I will choose from in a column and their corresponding price value in the next column. I need help figuring out how to get the results for lets say 10-15 combinations of these players that their salary is within a range of a certain amount.
Bookmarks