Randomly mix a team of certain players but fix certain ones Hi, I am trying to create an excel sheet where I can add say 16 golfers ( 4 players in 4 teams) on a list and then choose to fix say 3 of these players in a certain position on the table but then randomly mix the other 13 players.

I have enclosed a spreadsheet with and example and have tried...
https://www.excelforum.com/sho....wthread.php?t=143155