Finding maximum numbers that fall within a range

PTori82

Board Regular
Joined
Dec 5, 2012
Messages
64
Column A3 is a basketball player's name, B3 is his salary for the day and column J are his projected stats for the day.

I need to find the top 8 scores of column J that equal $50,000 from column B3. I also need their names (from column A3) associated with the results. The results can be placed in column N3.
 

Excel Facts

Difference between two dates
Secret function! Use =DATEDIF(A2,B2,"Y")&" years"&=DATEDIF(A2,B2,"YM")&" months"&=DATEDIF(A2,B2,"MD")&" days"
Column A: Listed vertically an infinite amount: Harden, Westbrook, Jokic, George, Irving, Mitchell, Gobert, Walker, Gasol, Faried
Column B: Listed vertically an infinite amount: Salary associated with player in column A: 12900, 11000, 10800, 9900, 9600, 8800, 8500, 8100, 7800, 6900
Column K: Listed vertically an infinite amount: 253.85, 236.17, 217.55, 193.28, 186.89, 178.72, 172.06, 165.33, 158.9, 145.33

With this data I am looking to maximize the points in column K of the associated players. But I only have $50,000 to spend. So with the $50,000 (data in column B) I am looking to pick the players that give me the most points under the constraint of only spending 50,000. The results will be shown beginning in column N3.

Thank you! I can email the specific spreadsheet as well if that helps.
 
Upvote 0

Forum statistics

Threads
1,215,268
Messages
6,123,970
Members
449,137
Latest member
yeti1016

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top