Getting Solver Results looking neater with variable position

When you have a variable number of positions like that, you'd need to do an IF statement to chec how many are at the position and then only populate that extra position with a name if there are that many guys.

For example, say you have a flex spot to allow you an extra D or M. So you can put in the formula normally for the first 2 Defenders because you know there will be one. Then for the third, you make an IF statement to check how many D positions were selected by solver. If it is greater than 2, then use the formula which pulls the 3rd D. If there are only two, then either put a blank, or pull in the 3rd Midfielder.

I hope this makes sense. If you still have trouble, email me the file and i can help better with the formula.