Optimizing a fantasy baseball lineup

"As Expected"

is a pretty big goal to achieve.

I think if you have your data sorted by position so all the C are together and 1B are togethere... That would be the first problem. Then .. Let me look at the code as 140 was the last row for today....

I see that the formulas in columns O to Q would also need updating for it to work with more or less players.....

I'd use a Dynamic Named Range for the Players and Positions to be more generic.
Using the names manager you could create a DNR called
Players = OFFSET(Sheet1!$B$2,0,0,COUNTA(Sheet1!$B:$B)+2,11)

Then use this Name in the formulas in the O:Q cells.

I'd also use a fancy CSE (Control+Shift+Enter) formula for the Max and Min of Start and End Row for player positions. YOU WILL STILL NEED TO SORT BY PLAYER POSITION.

Lastly in this newer version I made sure the 3 outfielders aren't the same person as the first version didn't have that check.

Now, maybe you could do this daily by simply copying in new data...