Peo told you the "mathematical way of figuring this out": brute strength,
given your statement of the problem. And it takes little work for what you
stated. Or are you looking for something dynamic/volatile in nature? If so,
please redefine your post.

DaveB

"Charles Rodriguez" wrote in
message ...
Thanks for the laugh! So really, no mathematical way of figuring this
out?

"Peo Sjoblom" wrote:

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.