Comparing data with maximum values

Occasional Visitor

Hello 

 

I have joined a fantasy football league and I am trying to work out which team of 6 players that I can pick will give me the most points based on data that I have gathered of each player for the total amount of money that I can spend on each player to create the team. Is there a function or way of manipulating the data to work out which combination of players will net me the maximum amount of points without going over the limit of money that you can spend for creating the team? 

 

Below I have attached an example of what I am trying to achieve.

 

Lewis

0 Replies