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 every Excel version.
Read article →INDEX returns the value at a given row (and optional column) of a range. Combined with MATCH it is the most flexible lookup in every Excel version.
Read article →SORTBY sorts one range by the values in another — even by a column you do not display.
Read article →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 returns the distinct values of a range, updating automatically as data changes.
Read article →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 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 is VLOOKUP turned sideways: it searches the top row and returns a value from a row below.
Read article →FILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.
Read article →Create dropdown lists in Google Sheets from a range or typed items, add colours, make dependent dropdowns, reject bad entries and keep shared sheets clean.
Read article →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, and formatting percentages properly.
Read article →HSTACK joins arrays horizontally — build a small report from separate results in one formula.
Read article →XLOOKUP finds a value in one range and returns the matching item from another. It looks in any direction, defaults to exact match, and has a built-in “not found” result.
Read article →