I have a spreadsheet that I need to find the max score given a cost constraint. I have 4 pages of data. Each page is a different type. Type 1 consists of 26 names (I must use one). Type 2 consists of 26 names (I must use two). Type 3 consists of 53 names (I must use two). Type 4 consists of 87 names (I must use two). Each of the names has an independent score and cost. If I were to calculate this manually, I would have 348,484,624,800 combinations. I don't have that kind of time. lol. Besides some of those combinations would be above the cost constraint. Can someone please help me?
Bookmarks