I need some help. I need to divide a group people in random teams and
have these groups reformed twice per month. here is an example. Lets say
i have a group of 10 people and need to divide them in random teams of
2

A
1
2
3
4
5
6
7
8
9
10

With the people in A1:A10, one way is to put
=RAND()
in B1:B10.

To randomize, select columns A:B and sort by column B. The teams are in A1:A2, A3:A4, A5:A6, etc.

Next time, randomize by sorting again.

Hope this helps.