Community lambdas.

Copyable definitions. Tested. Tagged. Star the ones you use.

Name	Signature	Description	Tags	★
REGEX.CAPTURE	(text, pattern, [group])	Capture a named regex group from a cell. Returns #N/A on no match, never the input.	text	1,204
TEXT.JSON.PARSE	(json, [path])	Parse a JSON string. Optional JSONPath ($..items[*].name). Returns spilled array.	text	761
DATE.WORKDAYS	(start, end, [holidays])	Working-day count excluding weekends and an optional holidays range. Inclusive of both endpoints.	date	643
TEXT.SLUGIFY	(s, [sep])	Lowercase, strip diacritics, replace non-alnum with the separator. Useful for stable keys.	text	521
PIVOT.CAST	(table, rows, cols, value, [agg])	Pivot a long table to wide. agg defaults to SUM.	reshape	488
PIVOT.MELT	(table, id_cols)	Unpivot a wide table into a tall one. Keeps id columns, melts everything else into name/value rows.	reshape, array	412
STATS.QUANTILE	(data, p, [method])	Interpolated quantile using a configurable method (linear, lower, higher, midpoint).	stats	359
IRR.BISECT	(cashflows, [guess])	Internal rate of return via bisection — more stable than the native IRR for irregular flows.	finance, stats	298
SIM.MONTECARLO	(n, fn)	Run n samples of a parameterless lambda, return the array of results.	simulation, stats	232
STATS.ZSCORE	(data)	Z-score normalize a 1D array. Skips empty cells.	stats	209
GEO.HAVERSINE	(lat1, lon1, lat2, lon2)	Great-circle distance in km between two lat/lon pairs.	geo, finance	174
BYROW.IF	(array, predicate)	Filter rows of a 2D array using a row-wise lambda. Equivalent to BYROW + FILTER, but eager.	array	87