AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Round tables for party12/5/2023 On the Excel Ribbon, click the Formulas tab.Here are the steps for creating that named range Next, a dynamic named range was created for the unassigned guests list - it will automatically grow or shrink as guest names are assigned to tables. In the screenshot below, some of the guest have been assigned to seats, and their names don’t appear in column D. For more information on this formula, see Excel Data Validation – Hide Previously Used Items. This is a multi-cell array formula (by DanielM.) that moves blank cells to the bottom of the list. Then, this formula was typed, and array entered (press Ctrl+Shift+Enter) To create this array formula, cells D1:D24 were selected. This list is used for the data validation drop down lists. In column D, there is an array formula to list the unassigned names. If a seat hasn’t been assigned, the formula will return the row number. In that case, this formula will return an empty string. If a guest has been assigned to a seat, their name will appear in column D on the TablePlan sheet. That formula was copied down to the last name. The first name is in cell B1, and this formula is in cell C1: On the Lists worksheet, there is a formula to check if the name in that row has been assigned a seat. If you’re interested in how the seating plan works, here are the details on the formulas and drop down lists. ![]() The drop downs were created with data validation. In the next column, there are drop down lists where you’ll select the guest names. The tables have the same colour coding as the tables, but that isn’t required - it just makes them easier to match up. To the left of the table diagram, there is a list of the tables and seat numbers. You can number and colour code the tables, to make it easier to keep track of things. Tip: To draw a circle, hold the Shift key while you use the Oval shape drawing tool. In the sample workbook, there are 3 tables, with 8 chairs at each table. On a sheet named TablePlan, use the Excel drawing tools to create the tables and chairs. In the sample workbook, you can clear out those names, and enter the names of your guests. Sort the names in alphabetical order, so the names will be easier to find in the data validation drop down lists. On a worksheet named Lists, the guest names are typed in column B. Here’s what a seating plan table looks like, after the guest names are selected. ![]() NOTE: There is a newer seating plan here: Excel Seating Plan with Charts After you’ve assigned a guest to a table, that guest’s name disappears from the drop down lists, so you can’t accidentally assign a guest to two different seats. Get this sample Excel seating workbook, enter the guest names on the Lists sheet, then fill the tables by selecting names from data validation drop down lists. If you’re having a party this weekend, you can plan your party seating with Excel.
0 Comments
Read More
Leave a Reply. |