by Wyn Hopkins

Excel Hash 2021

A bit of fun to be had and a challenge set by fellow Excel MVP Oz du Soleil. Finding a solution to the spare seat assigner. Our solution incorporates the following items:

1. Cutout person
2. Pick at least 2 from the following list: LET, LAMBDA, Dynamic Arrays, Power Query New Data Types
3. The EVEN function
4. Everything has to be integrated and justified–even the cutout person.
5. Everything in Excel is open for use, except VBA. So, go ahead and use Power Query, Power Pivot, Solver, Form Controls … whatever.

There’s no voting for this one but feel free to to give this a like!