Hi,

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

I would like a result like 1-4, 2-10, 9-5, 7-6, 8-3 Which function can give a result like that? I need combinations of people where each person cannot be in more than one team.

Is it possible in Excel?

Thank you