+ Reply to Thread
Results 1 to 5 of 5

Seating chart - table plans populate with names from other cells

  1. #1
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    250

    Seating chart - table plans populate with names from other cells

    Hi guys,

    I am thinking of an idea for a google sheet to have a column (let's say A1 down) filled with wedding guest names. In column B, I will allocate a table number, between 1-20.

    In Cell D (titled 'Table 1), how can I write a formula to retrieve the guest names who have (table) '1' allocated?

    Thank you!
    Thanks,

    R.



  2. #2
    Valued Forum Contributor
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2007
    Posts
    1,297

    Re: Seating chart - table plans populate with names from other cells

    see attached file.
    Formula used:

    HTML Code: 
    =IFERROR(INDEX($A$1:$A$15,SMALL(IF($B$1:$B$15=D$1,ROW($A$1:$A$15),""),ROW(1:1))),"")
    It's an array formula, so enter with CTRL+SHFT+ENT.
    Attached Files Attached Files
    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

    Modytrane

  3. #3
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    250

    Re: Seating chart - table plans populate with names from other cells

    Quote Originally Posted by modytrane View Post
    see attached file.
    Formula used:

    HTML Code: 
    =IFERROR(INDEX($A$1:$A$15,SMALL(IF($B$1:$B$15=D$1,ROW($A$1:$A$15),""),ROW(1:1))),"")
    It's an array formula, so enter with CTRL+SHFT+ENT.
    this looks great. thank you!

  4. #4
    Valued Forum Contributor
    Join Date
    11-27-2007
    Location
    New Jersey, USA
    MS-Off Ver
    2007
    Posts
    1,297

    Re: Seating chart - table plans populate with names from other cells

    1. Click on the * Add Reputation if you think this helped you
    2. Mark your thread as SOLVED when question is resolved

  5. #5
    Forum Contributor
    Join Date
    11-13-2015
    Location
    London
    MS-Off Ver
    MS 2016
    Posts
    250

    Re: Seating chart - table plans populate with names from other cells

    Just marked as solved, sorry!

    Already added rep :-)

+ 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