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 →Atul Vij
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 →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 →PERCENTOF Function in Excel: Share of the Total
PERCENTOF Function in Excel: Share of the Total
PERCENTOF returns a subset’s share of a total — mostly used inside GROUPBY and PIVOTBY to show % of total.
Read article →TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE Function in Excel: Text Before a Delimiter
TEXTBEFORE returns everything before a delimiter; TEXTAFTER everything after. They replace most LEFT/FIND and MID/FIND combinations.
Read article →FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML Function in Excel: Pick Values Out of XML
FILTERXML extracts values from XML with an XPath. Its famous side use: splitting text in versions without TEXTSPLIT.
Read article →TRANSPOSE Function in Excel: Flip Rows and Columns
TRANSPOSE Function in Excel: Flip Rows and Columns
TRANSPOSE turns a vertical range horizontal and vice versa, and stays linked to the source.
Read article →RAND Function in Excel: Random Decimal Between 0 and 1
RAND Function in Excel: Random Decimal Between 0 and 1
RAND returns a new random number between 0 and 1 on every recalculation — useful for random samples and shuffling.
Read article →OFFSET Function in Excel: A Range That Moves or Resizes
OFFSET Function in Excel: A Range That Moves or Resizes
OFFSET returns a range a set number of rows and columns away, optionally with a new size. Classic for rolling totals and dynamic chart…
Read article →PIVOTBY Function in Excel: A Cross-Tab Without a Pivot Table
PIVOTBY Function in Excel: A Cross-Tab Without a Pivot Table
PIVOTBY groups by rows and columns at once — regions down, months across — as a formula.
Read article →