LAMBDA: the day Excel let you write your own functions
Copy-pasting the same formula across a workbook used to be the only way to reuse logic - until LAMBDA let you name it and call it like any other Excel function.
LET
// 6 postsTutorials, tips, and deep dives on LET — every post from bianca.codes tagged LET.
LET posts
-
-
Build a Dynamic Summary Table Using BYROW and LAMBDA — No Pivot Table Required
You'll build a summary that calculates a custom metric for every row in your dataset without a pivot table, without helper columns, and without copying formulas down. BYROW plus a LAMBDA gives you …
-
BYROW and BYCOL: Apply Any Formula to Every Row or Column, Automatically
BYROW hands your function an entire row at a time. BYCOL does the same by column. Together they replace an entire category of 'drag this formula down and keep it updated' work — and when you combin…
-
Build a Rolling 12-Month Balance Tracker That Updates Without Touching a Formula
You'll build a balance tracker using SCAN and a structured table that extends itself as new rows come in. No helper columns, no fragile cell references, no 'just re-paste the formula down.' Add a r…
-
LET: How to Write Excel Formulas That You Can Actually Read Tomorrow
Complex formulas aren't the problem. Unreadable ones are. Before LET, you had to repeat the same range reference six times or accept that your formula was a black box. LET gives you named variables in
-
3-Minute Win: Name Your Intermediate Formula Steps With LET
One tweak to your most-used formula and it suddenly reads like plain English. LET() lets you name the messy middle parts — so next month's you won't need to reverse-engineer what current you was …