Forum Discussion
Patrick2788
Aug 09, 2026Silver Contributor
BigSpill: A 97‑Function Excel LAMBDA Library for Dynamic Arrays
What is BigSpill? BigSpill is an Excel LAMBDA library containing 97 functions across 10 categories, built from extensive experimentation with dynamic arrays. The goal is to provide elegant, efficien...
PeterBartholomew1
Sep 05, 2026Silver Contributor
I used a helper range to provide the lookup table from Braille to standard characters. The standard 1D lookup was based on a binary representation of the Braille letter. It turns out that the binary representation is standard but I wasn't using it because Excel uses row-major-order for flattening the 6 bits. Seems
TOCOL(BrailleChar="●", ,1)sorts the issue when introduced before the concatenation. Perhaps I should check it out and post on the original thread.