Forum Discussion
Stacking The Beatles in Excel: An Exercise in 3D stacking
The setup: You're provided with an Excel workbook with 12 sheets for 12 Beatles albums. All 12 sheets have the same fields, but the fields are not in the same order in each sheet. The goal: Roll...
Another go at this for 2025!
**Edited - cleaned it up a bit more.
StackNSortλ=
LAMBDA(three_dimensional_ref,
LET(
stack, HSTACK(three_dimensional_ref),
sorted, SORT(stack, , , 1),
wrapped, WRAPCOLS(TOCOL(sorted, , 1), ROWS(sorted) * (SHEETS()-1)),
header, TAKE(wrapped, 1),
result, UNIQUE(FILTER(wrapped, (TAKE(wrapped, , 1) <> 0))),
result
))
I can't even open the file without crashing Excel!
I had better check whether it is Excel or the files.