Randomizing players into teams

Hello all.
I am trying to organise a draft of pre determined players into 32 teams and was wondering if there was a way of doing this in Excel.

I have a list of 32 teams.
Each team has 18 positions.

Each requires 1 player to be randomly selected from a pre written list of 32 players.
This process needs to be repeated for the 18 positions.

So far I have created the 32 teams, 18 positions and then the lists of 32 players per position.

I was wondering if there is a formula in excel that could randomise this?

Any help would be amazing.

Andrew

.
I'm confused. Can't decide if you have 18 players total or 576 players total for 32 games.

If its the latter ... here is one approach :

Please Login or Register  to view this content.