LET Function in Excel: Name Parts of a Formula
LET assigns names to calculations inside a formula, so long formulas become readable and repeated parts are calculated once.
Read article →AREAS Function in Excel: How Many Blocks in a Reference
AREAS Function in Excel: How Many Blocks in a Reference
AREAS counts separate ranges in a reference — used with INDEX’s area_num argument to switch between tables.
Read article →GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA pulls a value from a pivot by field names, not by cell position — so your report keeps working when the pivot grows…
Read article →ISERR Function in Excel: Any Error Except #N/A
ISERR Function in Excel: Any Error Except #N/A
ISERR is TRUE for every error except #N/A. That lets you treat “not found” as normal while still catching real breakages like #DIV/0! or…
Read article →NA Function in Excel: Return #N/A on Purpose
NA Function in Excel: Return #N/A on Purpose
NA produces #N/A deliberately. Charts skip #N/A points instead of plotting them as zero.
Read article →TRIMRANGE Function in Excel: Cut Empty Edges Off a Range
TRIMRANGE Function in Excel: Cut Empty Edges Off a Range
TRIMRANGE removes empty rows and columns from the outside of a range, so formulas can point at whole columns without processing a million blanks.
Read article →CUBEMEMBER Function in Excel: A Label From the Data Model
CUBEMEMBER Function in Excel: A Label From the Data Model
CUBEMEMBER returns a member (like a year or product) from the Data Model, which CUBEVALUE can then reference.
Read article →MATCH Function in Excel: Find the Position of a Value
MATCH Function in Excel: Find the Position of a Value
MATCH returns the position of a value in a list — the “where is it?” half of INDEX/MATCH.
Read article →XMATCH Function in Excel: MATCH With Better Defaults
XMATCH Function in Excel: MATCH With Better Defaults
XMATCH returns the position of an item, defaulting to exact match, and can search from the end or use wildcards.
Read article →DGET Function in Excel: Get the One Matching Value
DGET Function in Excel: Get the One Matching Value
DGET returns a single value from the row that matches — and, usefully, refuses to guess when more than one row matches.
Read article →GROUPBY Function in Excel: A Pivot-Style Summary in One Formula
GROUPBY Function in Excel: A Pivot-Style Summary in One Formula
GROUPBY groups rows by one or more columns and aggregates values — a live summary table that updates as data changes, without refreshing a…
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 →