Excel Hash Seating Chart Planner - 2021

Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint... 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:    • Excel Hash 2021   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... #Excel #ExcelCampus #ExcelHash