# Excel: Limited Point Picks

#### tbird8057

##### New Member
Below is a table. I'm trying to pick 4 teams with whose points value add up to 52 or less with the greatest amount of Avg Wins. Let me know what other information I could provide. I'm not just posting to find out the answer, I want to learn how to figure it out in excel.

### Excel Facts

Save Often
If you start asking yourself if now is a good time to save your Excel workbook, the answer is Yes
I think I would;

(Assuming the above is in columns A:C) Add another column, Wins Per Pt, the formula in the first cell being =C2/B2.

Add another column showing the rank of the Wins Per Pt column.

Sort by the rank column.

Although not a dead cert (sometimes of course it's better adding two smaller values and there being no 'leftover' space rather than adding one large value and then not having space for more) its quite probable that the entries you want are the top ones.

Best regards
Richard

I think I would;

(Assuming the above is in columns A:C) Add another column, Wins Per Pt, the formula in the first cell being =C2/B2.

Add another column showing the rank of the Wins Per Pt column.

Sort by the rank column.

Although not a dead cert (sometimes of course it's better adding two smaller values and there being no 'leftover' space rather than adding one large value and then not having space for more) its quite probable that the entries you want are the top ones.

Best regards
Richard

I think i'm looking for how to write a script that will brute force test all possible combinations since the points have to be equal or less than 52.

thanks

Did you try my suggestion above? I did, it took about a minute to get the answer.

Replies
1
Views
97
Replies
1
Views
75
Replies
5
Views
183
Replies
7
Views
258
Replies
0
Views
127

1,203,428
Messages
6,055,325
Members
444,781
Latest member
rishivar

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back