Equal "Distribution"

[Charles Rodriguez]

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.

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[Charles Rodriguez]

Thanks for the laugh! So really, no mathematical way of figuring this out?

 

[Peo Sjoblom]

It is a question that pops up now and then, I know there has been some
answers using brute strength,
if you go here

http://groups.google.es/advanced_group_search?q=group:*excel*&scoring=d&lr=lang_en&hl=en

and search for table seating (or something similar) I am sure you will find
some hits on how to at least use excel in some way (usually by copying down
a formula)

--
Regards,

Peo Sjoblom

(No private emails please)

 

[David J. Braden]

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