Top n Solutions

Hello,

 

I am using the excel solver as an optimizer to find the max value for a certain cell given a set of conditions. Specifically it is being used to optimizer daily fantasy basketball lineups. Therefore, the players that are part of the optimal lineup based on what I have projected for their fantasy point total are highlighted in green. Is there a way for me to find the top n lineups where lineup 1 has the max score, lineup 2 has the second max score, etc. and store them in a table so I can see the top ten lineups in one place for example?

By: Charlie

Leave a Reply

Your email address will not be published. Required fields are marked *