Excel Problem I just can’t get my head around.

Giganews Newsgroups
Subject: Excel Problem I just can’t get my head around.
Posted by:  Ant (ant.sne…@virgin.net)
Date: Sun, 30 May 2004

I am trying to solve a problem that I think Excel should be able to help me
with, if only I knew how!

The problem is this.  I am organising an event and expecting around 40-50
people, each person should visit each of the 6 stands with a group of other
guests.  After visiting the first stall, each person should then move onto
another stall; however they should not meet anyone at the second stall that
they were with previously at the first.  This should then continue until
every one has visited all 6 stalls and not met with anyone they have been
with at a stall before.  I expect there to be approx 10 people at any one
stall at a time e.g. 60 people attend / 6 stalls = 10 at a stall.

I first thought this would be a simple problem, start a table in Excel and
find a pattern then copy the pattern down, but the more I try the more
frustrated I get.  Any suggestions welcome.

Replies