Function Problems

How to Copy Names to a Seating Chart Based on Table Text in Excel

Algirdas JasaitisAlgirdas Jasaitis Nov 10, 2026 869 views

Question details

The user needs to automatically populate a seating chart with guest names based on the table assignments listed in another column.

How to Copy Names to a Seating Chart Based on Table Text in Excel
Product
Excel
Device & OS
not provided
Scenario
Organizing an event and assigning guests to tables using a master spreadsheet list.
Observed behavior
The user wants an automated formula to extract and display all names assigned to a specific table in a designated area of the seating chart worksheet without copying them manually.
Before you start

Ensure that your guest list is organized with one column dedicated to guest names and another dedicated to their assigned table names (e.g., 'Table 1'). Verify that the table labels in your dataset exactly match the labels you will use in your formula.

Solution 1Recommended

Use the FILTER Function to Automatically Populate Tables

The FILTER function is the most efficient way to extract a list of names matching a specific criterion, such as a table name, and spill them into your seating chart automatically.

Dynamic array formulas like FILTER allow you to write a formula in a single cell that outputs results into multiple adjacent cells. This eliminates the need to manually drag formulas down or use complex array operations.

1
Open the Seating Chart Worksheet

Navigate to the worksheet or area where you have designed your seating chart. Select the top empty cell under your first table header (e.g., under the title 'Table 1').

2
Enter the FILTER Formula

Type the formula: =FILTER('guest list'!C14:C103, 'guest list'!J14:J103="Table 1", ""). In this example, 'guest list'!C14:C103 represents the column containing guest names, and 'guest list'!J14:J103 represents the column containing the table assignments.

3
Press Enter to Spill Results

Press Enter. The application will automatically spill all the guest names assigned to 'Table 1' into the cells immediately below your formula cell.

4
Repeat for Other Tables

Copy the formula to the starting cell for your next table. Change the text 'Table 1' in the formula to 'Table 2', 'Table 3', etc., to populate the remaining tables on your seating chart.

Dynamic Arrays: Ensure you leave enough empty cells below the formula cell to allow the list of names to spill. If there is existing text blocking the path, you will receive a #SPILL! error.
Use WPS Spreadsheet for Event Planning

Easily Manage Seating Charts with WPS Spreadsheet

WPS Spreadsheet fully supports dynamic array functions like FILTER, making it incredibly simple to organize guest lists and automatically generate dynamic seating charts. It is a powerful, free tool for all your data management needs.

  1. 1. Open your Guest List in WPS Spreadsheet: Launch WPS Office, open the Spreadsheet module, and load your event planning workbook containing the master guest list.
  2. 2. Select the Destination Cell: Click on the first empty cell in your seating chart where you want the names for a specific table to begin appearing.
  3. 3. Apply the FILTER Function: Enter the FILTER formula to extract the names based on the table column, and press Enter to instantly populate your table seating list.
Fully supports advanced dynamic array formulas including FILTER and SORT.Highly compatible with Microsoft Excel (.xlsx) and (.csv) file formats.Provides a clean, tabbed interface perfect for managing multiple event worksheets simultaneously.Free and lightweight, running smoothly on Windows, Mac, and Linux.
microsoft office alternative - wps office

Frequently Asked Questions

What should I do if my formula returns a #SPILL! error?

A #SPILL! error occurs when the cells where the formula intends to output the matching guest names are not empty. Clear any text, formatting, or data in the cells directly below your formula to allow the list to expand properly.

Can I use this method if I have an older version of Excel?

The FILTER function is only available in Microsoft 365, Excel 2021, and newer versions of WPS Office. If you are using an older version, you may need to use a complex combination of INDEX and AGGREGATE functions, or upgrade to a modern suite like WPS Office for free.

How do I sort the guest names alphabetically at each table?

You can wrap the FILTER function inside a SORT function. For example, use =SORT(FILTER(names_range, tables_range="Table 1", "")) to automatically return the matching names in alphabetical order at the table.