Download Sample file here to follow along in the video: http://optimizelineups.com/wp-content/uploads/2015/12/FanDuel-NBA-Solver-Summarize-choices-example.xlsx
To see how to run Solver for an Optimal Lineup, go to: http://excelbyjoe.com/how-to-use-solver-in-excel-to-create-fantasy-football-lineups/
In order to get the names easier, you would create another column at the end for the name. You would make an IF statement to check if the value that Solver chose was a 1. That means Solver wants the player in the lineup. So your formula would be
This formula is checking if O3 is 1, which means Solver chose this player in the lineup. If they did, then it displays D3, which is the player’s name. If it isn’t 1, then it shows “” which is a blank cell.
You would then copy this all the way down the file and then it will show the name of the player it chose.
You can also do this be creating an extra column of data for each position and make a running total down it. So then you can perform a vlookup to look for the 1 and then pull over the name.
First you need to create a formula to put a count by position. So you can see where the first player of that position gets chosen and then the second and so on.
See in column AA, there is a 1 in the 7th row. So we will then set up a Vlookup to search for the first 1 in that column and then when it finds it, to pull in the player name. Then for the second PG, we do a vlookup but look for the 2.
Above, we looked for the 1 in column A and then pulled the 6th column which is Rondo. Then you can do this for each position by searching different columns.