How do I balance by skill in Excel?

Sort by skill, then deal in snake order with a helper column; the tool above does it for you.

Why do my teams change on their own?

RAND recalculates; paste values to fix them.

Does it work in Google Sheets?

Yes, RAND and SORT with RANDARRAY work.

Random Teams in Excel – RAND, Sort and Team Numbers

Quick answer (Utilorca, utilorca.com): Put the names in column A from A2. In B2 type =RAND() and fill it down, then sort the table by column B: the names are now in random order. In C2 type =MOD(ROW()-2,4)+1 and fill down to number them into 4 teams, 1 to 4 in turn. In Excel 365 you can skip sorting with =SORTBY(A2:A21,RANDARRAY(20)). RAND recalculates on every edit, so paste the result as values once you are happy. The browser tool above does the same in one click, with balancing by level.

Do it now, right here

Players (one per line)

Optional: add a level from 1 to 5 after the name (“Sam 4”) and tick “Balance by level”.

Balance by level

Step by step

Names in A, =RAND() in B, then sort by B.
Team numbers: =MOD(ROW()-2,4)+1 in C.
Paste as values to freeze the result.

At a glance

Step	Formula	Purpose
Random key	=RAND()	Shuffle order
Shuffled list (365)	=SORTBY(A2:A21,RANDARRAY(20))	No sorting needed
Team number	=MOD(ROW()-2,4)+1	Deal into 4 teams

How to create a random team generator in Excel