+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 : Random seating chart no repeats

  1. #1
    Registered User
    Join Date
    09-04-2011
    Location
    ny,ny
    MS-Off Ver
    Excel 2003
    Posts
    1

    Random seating chart no repeats

    Have networking event I'm running. 20 people, 5 tables. We spend 5 minutes at each table, then move to another table. Is there a formula I can use that ensures no two people will be at the same table more than once.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Random seating chart no repeats

    Welcome to the forum.

    From a tabulation of solutions by Warwick Harvey:

    [[1, 2, 3, 4], [5, 6, 7, 8], [9, 10, 11, 12], [13, 14, 15, 16], [17, 18, 19, 20]]

    [[1, 5, 9, 13], [2, 10, 15, 17], [3, 8, 14, 20], [4, 7, 12, 19], [6, 11, 16, 18]]

    [[1, 7, 11, 15], [2, 9, 16, 20], [3, 6, 13, 19], [4, 8, 10, 18], [5, 12, 14, 17]]

    [[1, 8, 12, 16], [2, 11, 14, 19], [3, 5, 15, 18], [4, 6, 9, 17], [7, 10, 13, 20]]

    [[1, 6, 10, 14], [2, 12, 13, 18], [3, 7, 16, 17], [4, 5, 11, 20], [8, 9, 15, 19]]
    Entia non sunt multiplicanda sine necessitate

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1