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 →Atul Vij
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 →HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP Function in Excel: Look Up Across the Top Row of a Table
HLOOKUP is VLOOKUP turned sideways: it searches the top row and returns a value from a row below.
Read article →FILTER Function in Excel: Return Every Row That Matches
FILTER Function in Excel: Return Every Row That Matches
FILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.
Read article →Google Sheets Dropdowns and Data Validation (With Coloured Chips)
Google Sheets Dropdowns and Data Validation (With Coloured Chips)
Create dropdown lists in Google Sheets from a range or typed items, add colours, make dependent dropdowns, reject bad entries and keep shared sheets…
Read article →Percentage of Total and Percentage Change in Excel (Without #DIV/0! Errors)
Percentage of Total and Percentage Change in Excel (Without #DIV/0! Errors)
Share of total, growth vs last month, contribution by region and year-on-year change — the correct formulas, absolute references, handling zero and blank values,…
Read article →HSTACK Function in Excel: Put Arrays Side by Side
HSTACK Function in Excel: Put Arrays Side by Side
HSTACK joins arrays horizontally — build a small report from separate results in one formula.
Read article →XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP Function in Excel: The Modern Lookup That Replaces VLOOKUP
XLOOKUP finds a value in one range and returns the matching item from another. It looks in any direction, defaults to exact match, and…
Read article →FORECAST Function in Excel: Straight-Line Forecast (Older Name)
FORECAST Function in Excel: Straight-Line Forecast (Older Name)
FORECAST predicts a value on a straight-line trend. It is a compatibility function: Excel keeps it so workbooks from Excel 2007 and earlier still…
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 →