|re: "I tried Excel but that didn't work for me"|
Excel worked for me!
I'll assume that you have column headings in Row 1 [Skips; 2nds; 3rds] so that your list of names starts in Row 2.
I'll further assume that your lists are in Columns A:C.
1 - In D2 enter this formula:
2 - Drag this down to the bottom of your list, then drag it over to Column F.
3 - This should fill D2:F[the bottom of your list] with Random numbers.
4 - In G2 enter this formula:
5 - Drag this down to the bottom of your list, then drag it over to Column I
This should produce Random teams in Columns G:I
Now, I should warn you that it is possible that the RAND function will produce more than one of the same number in a given column, However, the odds are very, very slim since RAND produces a number between 0 and 1 that has up to 16 decimals places. Should this be an issue, let us know and we'll see what else we can offer.
You should also be aware that the RAND function is volatile meaning that it will recalculate every time the sheet recalculates and will therefore create new random teams. You can eliminate this issue by selecting either all of the Random numbers or all of the Random teams and doing a Copy...Paste Special...Values to lock the values in the cells.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.