complex permiation/combo formula
I am trying to come up with a formula on excel and any help would be much appreciated.
There are 4 columns titled: Player Name, Player Position, Projected Points, Player Salary.
I have a total of 103 players that consist of Center, Forward and Guard positions. Each player has a position, projected points value, and salary value.
I need to know all possible 8 player combinations (lineups) that have the highest projected point value with a total salary under $100,000. The 8 player lineup will consist of 2 guards, 2 forwards, 2 centers and the final 2 can be any of the 3 (utility).
| Attachment | Size |
|---|---|
| Sample NBA formula.xlsx | 14.03 KB |

Recent comments
6 years 36 weeks ago
7 years 22 weeks ago
7 years 34 weeks ago
7 years 37 weeks ago
7 years 38 weeks ago
7 years 43 weeks ago
7 years 51 weeks ago
8 years 1 day ago
8 years 1 day ago
8 years 2 days ago