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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →IFNA Function in Excel: Handle “Not Found” Only
IFNA Function in Excel: Handle “Not Found” Only
IFNA replaces only #N/A — the “not found” result of lookups — and lets real errors show.
Read article →CONCATENATE Function in Excel: The Old Way to Join Text
CONCATENATE Function in Excel: The Old Way to Join Text
CONCATENATE joins text pieces. It still works for compatibility, but it cannot take a range — CONCAT and TEXTJOIN replaced it.
Read article →INDEX Function in Excel: Return the Value at a Row and Column Position
INDEX Function in Excel: Return the Value at a Row and Column Position
INDEX returns the value at a given row (and optional column) of a range. Combined with MATCH it is the most flexible lookup in…
Read article →SORTBY Function in Excel: Sort by Another Column
SORTBY Function in Excel: Sort by Another Column
SORTBY sorts one range by the values in another — even by a column you do not display.
Read article →MIDB Function in Excel: Middle Bytes
MIDB Function in Excel: Middle Bytes
TextLevel: ExpertAvailable in: Excel 2007+MIDB is the byte-based version of MID; identical to MID in English setups.Syntax=MIDB(text,2,3)ArgumentWhat it.
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 →TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TextLevel: IntermediateAvailable in: Excel 2019+TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.Syntax=TEXTJOIN(delimiter.
Read article →SERIESSUM Function in Excel: Sum of a Power Series
SERIESSUM Function in Excel: Sum of a Power Series
SERIESSUM adds a power series a1·x^n + a2·x^(n+m) + ..., e.g. to approximate e^x or sin(x) with a few terms.
Read article →