There is no such function, you need to use brute strength

--
Regards,

Peo Sjoblom

(No private emails please)


"Charles Rodriguez" wrote in
message ...
The real problem is I don't know how to phrase this question in Excel's
Help
feature. What I'm trying to do is as follows:

I have 4 groups of people (i.e. Group 1, Group 2, etc.). In each group
are
4 different people. So total, there are 16 people.

I'm trying to mix and match so that each person gets into a group with a
different person every time. Does that make sense? I'm not sure if there
is
a function/formula that can do this.