Randomly Assign Teams in Google Sheets #shorts

How to randomly assign participants to teams in Google Sheets.

All you have do do is use the WRAPROWS function to split the participants into various teams, and then use the Randomize Range feature to switch up the team placements.

#googlesheets #googlesheetstips #gsheets

[carolyneakisa]

So how do I delete the participants column and still maintain the assigned team

[cubesoftwaresolutions]

Is there any way to give a "ranking" to each participant so you can randomly "balance" the teams for strengths/weaknesses