Need help with Solver or a better option

New Contributor

I am not sure if this can be done in solver or if there is something better to use.


I am querying a large data set of golf stats from multiple excel spreadsheet into 1 combined stats spreadsheet for fantasy golf.  Now that I have that, I want to analyze the data to get the bet options.  Below is my info.


My objective - Maximum Score.  I have 2 different custom scores I am looking at, I will decide on which one to use after analysis


Item to Change - Golfers.  Can be either the name, identifier or combo



Must chose only 6 golfers

Max $ spent

Min $ spent

Number of Lineups to create - 1 to XXX


I will be choosing a subset of X number of golfers from X number of entries (i.e. 45 of 150) for consideration


I would also like to set a maximum number of times to use each (i.e. Golfer A max 6 times, Golfer B max 3, etc.)


When solved, I would like the results on a separate tab in separate cells:

G1, G2, G3, G4, G5, G6, Total Score, Total Cost.


Any help is greatly appreciated.

1 Reply
See if =Subtotal(… can be used, as it gives you totals (Avg/Max/Min/Sum etc) based on filtered records. If not, see if Pivot Tables will help. Both could be linked to other tabs.
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
50 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
32 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
15 Replies
Dev channel update to 80.0.355.1 is live
josh_bodner in Discussions on
67 Replies