DROP Function in Excel: Remove First or Last Rows
DROP removes rows or columns from the start (positive) or end (negative) of an array — e.g. strip headers or total rows.
Read article →Atul Vij
ISREF Function in Excel: Is It a Valid Reference?
ISREF Function in Excel: Is It a Valid Reference?
ISREF returns TRUE when its argument is a reference. With INDIRECT it checks whether a sheet name typed by a user exists.
Read article →SMALL Function in Excel: The k-th Smallest Value
SMALL Function in Excel: The k-th Smallest Value
StatisticalLevel: IntermediateAvailable in: Excel 2007+SMALL returns the k-th smallest number — bottom-N lists and the earliest dates.Syntax=SMALL(array.
Read article →VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT Function in Excel: Any Value as Text
VALUETOTEXT converts any value to text; strict mode adds quotes around text so you can see stray spaces.
Read article →CUBEVALUE Function in Excel: Numbers Straight From the Data Model
CUBEVALUE Function in Excel: Numbers Straight From the Data Model
CUBEVALUE pulls a measure from the Power Pivot Data Model into any cell, so you can build free-form reports instead of being stuck with…
Read article →ADDRESS Function in Excel: Build a Cell Address as Text
ADDRESS Function in Excel: Build a Cell Address as Text
ADDRESS returns a cell reference as text from row and column numbers — often combined with MATCH to report “where” something is.
Read article →COLUMN Function in Excel: Column Number of a Cell
COLUMN Function in Excel: Column Number of a Cell
COLUMN returns the column number (A = 1). Handy for VLOOKUP formulas that fill across.
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 →DAVERAGE Function in Excel: Average With a Criteria Table
DAVERAGE Function in Excel: Average With a Criteria Table
DatabaseLevel: ExpertAvailable in: Excel 2007+DAVERAGE averages a column for rows that meet the criteria range.Syntax=DAVERAGE(database, field.
Read article →COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF Function in Excel: Count Cells That Meet a Condition
COUNTIF counts cells that meet one condition. It is also the simplest duplicate checker.
Read article →ERROR.TYPE Function in Excel: Which Error Is It?
ERROR.TYPE Function in Excel: Which Error Is It?
ERROR.TYPE returns a number for each error (1 #NULL!, 2 #DIV/0!, 3 #VALUE!, 4 #REF!, 5 #NAME?, 6 #NUM!, 7 #N/A) so you can…
Read article →EXPAND Function in Excel: Grow an Array to a Fixed Size
EXPAND Function in Excel: Grow an Array to a Fixed Size
EXPAND pads an array to a given number of rows and columns — handy before VSTACK when pieces have different widths.
Read article →