Please watch the video below to see how to build a spreadsheet lineup optimizer tool in Excel.
I use Golf as the example but this can be used on any sport.
This video covers the basics of what you need to build a good lineup optimizer tool. To see the complete course which goes into everything, including stacking players, multiple positions, macros, team limits and more, go to https://spreadsheetschooldfs.com/p/bulk-lineups-without-solver
To see my full course on using spreadsheets for helping you in daily fantasy sports, check out https://spreadsheetschooldfs.com/
Use code MAIL for 10% off the main course.
Download the sample file here to follow along: https://excelbyjoe.com/wp-content/uploads/2020/10/build-lineup-optimizer.xlsx