Selected Answer
Glad you enjoy it here :)
Here is a solution that should work (probably not the best but currently limited by my phone right now).
Use this UDF function to generate the random numbers: non-repeating list of random numbers in excel
In the function, first argument put1 and second argument put the number of people you have and then put that number again for the 3rd argument.
That functiom gives you numbers in 1 cell. Copy/paste valeues to keep only the numbers (select the cell and hit ctrl+c alt+e+s+v Enter).
Then use text-to-columns feature to split the numbers into their own cells. Transpose those numbers so they move from being in a row to being in a column.
Put a number for each participant, start at 1 and integrate up until the end.
Now, the first 5 numner that were randomely generated can make the first team and the n3xt 5 the next team where each number correspomds to a participant.
It seems like a lot of work but its really not. Using the udf mght be the trickiest part and i think we have a tutorial on here that tells you how to install amd use them - they are just macros that create new functions in the worksheet.
(Theres probably a crazy worksheet formula that will do this but like i said, im on my phone now and these steps are pretty straight forward anyway. If you dont understand anything, reply here and ill get back to you.)