UNIQUE Function in Excel: Distinct List Without Remove Duplicates
UNIQUE returns the distinct values of a range, updating automatically as data changes.
Read article →Category Archives: Excel Functions A–Z
Every Excel function explained with syntax, examples, common errors and powerful combinations — from beginner to expert.
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 →TAKE Function in Excel: First or Last N Rows of a Range
TAKE Function in Excel: First or Last N Rows of a Range
TAKE returns the first (or last, with a negative number) rows or columns of an array — perfect for top-N reports.
Read article →LET Function in Excel: Name Parts of a Formula
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 →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 →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 →IFS Function in Excel: Several Conditions Without Nested IFs
IFS Function in Excel: Several Conditions Without Nested IFs
IFS checks conditions in order and returns the value for the first TRUE one — cleaner than nesting IF inside IF.
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 →VLOOKUP Function in Excel: Look Up a Value in the First Column of a Table
VLOOKUP Function in Excel: Look Up a Value in the First Column of a Table
VLOOKUP finds a value in the first column of a table and returns a value from another column in the same row.
Read article →SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE Function in Excel: Generate a List of Numbers or Dates
SEQUENCE creates a spilled list of numbers — serial numbers, calendars, repeating patterns.
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 →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 →