Hello all,

Like I explained in my introduction thread, I was driven here because I need a solution for my Madden 13 Online league. My friends and I would get together and do a fantasy draft online to create random teams within the game. In the new game, Madden 13, this feature is gone. However, I wanted to know if anyone knew a formula to designate any player names i put in on an excel sheet to 32 teams, randomly.

Heres what I mean:

I input 32 Quarterbacks into the excel doc, I input 32 Team names into the Excel doc, I want to scramble these 32 guys to random teams.

I have a sheet that randomly generates teams..but it only does it for 4 teams and I can not figure out how to adjust the formula for 32 nfl football teams. I uploaded the excel file i found and was trying to use.

Again it is using only 4 teams, I need 32, and for each team to only get 1 player...

any help or direction is GREATLY appreciated!

Thanks!

Team-Generator1.xls