Skip to content

Instantly share code, notes, and snippets.

View RackofLambda's full-sized avatar

David Clements RackofLambda

  • Philippines
View GitHub Profile
@RackofLambda
RackofLambda / DYNAMIC_ARRAY_HELPER_FUNCTIONS.txt
Last active January 28, 2026 08:45
A collection of Microsoft Excel LAMBDA functions for scanning tables and arrays.
/* List of LAMBDA functions in this collection:
--------------------------------------------
LISTBY --------->> Groups all values from a table or array by distinct item and returns a jagged array of associated lists.
INSTANCENUM ---->> Returns the running count of distinct items in an unordered table or array.
RUNNINGTOT ----->> Returns the running total of values by distinct item in an unordered table or array.
RUNNINGTOT2 ---->> Returns the running total of values by distinct item in an unordered table or array, with the option to prioritize order by date.
JOINROWS ------->> Creates a key identifier row by combining the values of each row in an array on a column-by-column basis.
JOINCOLS ------->> Creates a key identifier field by combining the values of each column in an array on a row-by-row basis.
SCANBYROW ------>> Scans an array in row-major order by applying a LAMBDA to each value and returns an array of intermediate results for each row.
SCANBYCOL ------>>
@RackofLambda
RackofLambda / ARRAY_TRANSFORMATIONS.txt
Last active December 21, 2025 12:19
A collection of Microsoft Excel LAMBDA functions for transforming tables and arrays.
/* List of LAMBDA functions in this collection:
--------------------------------------------
CALENDARRAY ---->> Generates a monthly calendar for the specified number of months.
CROSSJOIN ------>> Returns the Cartesian product of two tables or arrays.
CROSSJOINM ----->> Returns the Cartesian product of multiple arrays.
KRON ----------->> Returns the Kronecker product of two arrays.
PERMA ---------->> Returns all permutations or combinations, with or without repetitions, for a given number of items.
REPTA ---------->> Repeats a range or array vertically or horizontally a specified number of times.
REPTROWS ------->> Repeats each row in a range or array a specified number of times.
REPTCOLS ------->> Repeats each column in a range or array a specified number of times.
@RackofLambda
RackofLambda / PRIME_FACTORIZATION.txt
Last active December 21, 2025 12:20
A collection of Microsoft Excel LAMBDA functions related to Prime Factorization.
/* List of LAMBDA functions in this collection:
--------------------------------------------
ISPRIME -------->> Determines if a number is prime.
FACTORS -------->> Returns all factors of a number.
PF ------------->> (recursive) Returns the prime factorization of a number.
PF_LCM --------->> Returns the least common multiple of integers. Extends the native LCM return limits from 2^53 to 10^308.
*/
/* FUNCTION NAME: ISPRIME