Forum Discussion
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...
BigSpill v1.2.0 has been released with 5 new functions:
Instanceλ
Assigns instance numbers to unsorted values in a 1D array.
Waveλ
Generates a vertical 1D “wave array” from a crest value and optional repetition count.
GroupIndexλ
Assigns numerical group indices to a 1D array (horizontal or vertical).
Occurrenceλ
Selects the Nᵀᴴ occurrences of rows from a 2D array by locating the Nᵀᴴ instance from a crit_vector.
OccurrenceRangeλ
Selects a range of occurrences (start → end or start → end‑of‑array) from a 2D array.