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 →Atul Vij
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 →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 →