Hi,
Essentially what you want to do is put the teams in a random order.
- Give each team a distinct number (let's call is the TeamID) between 1 and 20.
- Put twenty =RAND() formulas in your worksheet to generate 20 random numbers
- Use RANK() and COUNTIF() to calculate the distinct ranking of each random number. Example here.
- Map the distinct ranking to eachTeamID to determine the order of your teams.
- Note that RAND() is volatile, so each time the worksheet calculates you will get a new random team order.