SCAN Function in Excel: Running Totals in One Formula
SCAN walks through an array carrying an accumulator and returns every intermediate result — running totals, running balances, running max.
Read article →Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER Function in Excel: Text After a Delimiter
TEXTAFTER returns the text that follows a delimiter — domains from emails, surnames, file extensions.
Read article →MAKEARRAY Function in Excel: Generate a Grid From Row and Column Numbers
MAKEARRAY Function in Excel: Generate a Grid From Row and Column Numbers
MAKEARRAY builds an array of a given size, computing each cell from its row and column number.
Read article →BYROW Function in Excel: Apply a Calculation to Each Row
BYROW Function in Excel: Apply a Calculation to Each Row
BYROW runs a LAMBDA on each row of an array and returns one result per row — row totals, row maximums, row checks.
Read article →FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML extracts values from XML with an XPath. Its famous side use: splitting text in versions without TEXTSPLIT.
Read article →TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE returns everything before a delimiter; TEXTAFTER everything after. They replace most LEFT/FIND and MID/FIND combinations.
Read article →BYCOL Function in Excel: Apply a Calculation to Each Column
BYCOL Function in Excel: Apply a Calculation to Each Column
BYCOL is BYROW turned sideways: one result per column.
Read article →UNIQUE Function in Excel: Distinct List Without Remove Duplicates
UNIQUE Function in Excel: Distinct List Without Remove Duplicates
UNIQUE returns the distinct values of a range, updating automatically as data changes.
Read article →MAP Function in Excel: Transform Every Value in an Array
MAP Function in Excel: Transform Every Value in an Array
MAP applies a LAMBDA to every item of one or more arrays and returns an array of results.
Read article →REDUCE Function in Excel: Boil an Array Down to One Result
REDUCE Function in Excel: Boil an Array Down to One Result
REDUCE is SCAN that returns only the final result — useful for repeated clean-up steps.
Read article →TEXTSPLIT Function in Excel: Split Text Into Cells
TEXTSPLIT Function in Excel: Split Text Into Cells
TEXTSPLIT splits text by a delimiter into columns and/or rows — a formula version of Text to Columns that updates automatically.
Read article →LAMBDA Function in Excel: Create Your Own Excel Functions
LAMBDA Function in Excel: Create Your Own Excel Functions
LAMBDA turns a formula into a reusable custom function. Save it in Name Manager and use it like any built-in function — no VBA.
Read article →