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 →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
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 →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 →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 →INDIRECT Function in Excel: Build a Reference From Text
INDIRECT Function in Excel: Build a Reference From Text
INDIRECT turns text such as "Mar!B5" into a real reference — the key to dependent dropdowns and summary sheets that switch between monthly tabs.
Read article →LARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
LARGE Function in Excel: The k-th Largest Value (Top 3, Top 10)
LARGE returns the k-th largest value; SMALL returns the k-th smallest. Together they build top-N lists in any version.
Read article →DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT Function in Excel: Count Numbers With a Criteria Table
DCOUNT counts numeric cells in a column for matching rows. Use DCOUNTA to count any non-blank cell instead.
Read article →ISNA Function in Excel: Is It “Not Found”?
ISNA Function in Excel: Is It “Not Found”?
ISNA returns TRUE only for #N/A — the “not found” result — so you can react to missing lookups specifically.
Read article →