Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
This seating chart planner is packed with features to plan events or classrooms. It optimizes for small groups or families to use the least number of rows or tables. It also has user views to help attendees find their seat, and back end setup for sorting, row/table size, floor plan layout and more.

This solution is my submission for episode 3 of Excel Hash. Excel Hash is a friendly competition with my fellow Excel MVPs and YouTubers where we must create any solution in Excel by using a list of ingredients.

#️⃣Excel Hash Playlist: https://www.youtube.com/playlist?list=PLHrPHBbDHgT1OUshE6AFf5AJqJdhKhJh_

Watch the other submissions at the link above, and support their channels by liking and subscribing.

We had to use 4 of the following Excel features (ingredients) in the solution.

1. LET Function
2. Cutout People (required)
3. EVEN Function (required)
4. LAMBDA Function
5. Dynamic Arrays Formulas
6. Power Query Custom Data Types

Chapters:
00:00 Intro
00:55 Excel Hash Explained
01:34 Ingredient #1 Custom Data Types
02:30 Ingredient #2 Dynamic Array Formulas
03:03 Ingredient #3 Even Function
03:34 Ingredient #4 Cutout People
04:19 Group Optimization Feature
05:22 Conclusion

⬇️ Download the file and read the post:
https://www.excelcampus.com/functions/seating-chart-planner/

#Excel #ExcelCampus #ExcelHash