Top N With Criteria in Excel: Biggest Orders by Region, Month or Customer
Get the top 5 values that meet a condition — and the rows behind them — with LARGE+IF, AGGREGATE, FILTER+SORT+TAKE and SORTBY, in old…
Read article →Atul Vij
LOOKUP Function in Excel: The Old Lookup With a Famous Trick
LOOKUP Function in Excel: The Old Lookup With a Famous Trick
LOOKUP is an older function that needs sorted data for normal use — but its array form powers the well-known “last match” trick in…
Read article →TOCOL Function in Excel: Turn a Grid Into One Column
TOCOL Function in Excel: Turn a Grid Into One Column
TOCOL flattens a 2-D range into a single column, optionally skipping blanks and errors. TOROW does the same into a row.
Read article →SORT Function in Excel: Sort Data With a Formula
SORT Function in Excel: Sort Data With a Formula
SORT returns a sorted copy of a range; the original stays untouched and the result re-sorts as data changes.
Read article →VSTACK Function in Excel: Stack Tables Vertically
VSTACK Function in Excel: Stack Tables Vertically
VSTACK appends ranges one below another — combine monthly sheets or regional lists without copy-paste.
Read article →RANDBETWEEN Function in Excel: Random Whole Numbers for Test Data
RANDBETWEEN Function in Excel: Random Whole Numbers for Test Data
RANDBETWEEN returns a random integer between two numbers. It recalculates on every change — convert to values when you want it fixed.
Read article →CHOOSE Function in Excel: Pick From a List by Number
CHOOSE Function in Excel: Pick From a List by Number
LookupLevel: IntermediateAvailable in: Excel 2007+CHOOSE returns the n-th item from a list of values you type in the formula.Syntax=CHOOSE(index_num.
Read article →DSUM Function in Excel: Sum With a Criteria Table
DSUM Function in Excel: Sum With a Criteria Table
DSUM adds a column for the rows that match a criteria range on the sheet. It looks old-fashioned, but it shines when a manager…
Read article →LET Function in Excel: Name Parts of a Formula
LET Function in Excel: Name Parts of a Formula
LET assigns names to calculations inside a formula, so long formulas become readable and repeated parts are calculated once.
Read article →AREAS Function in Excel: How Many Blocks in a Reference
AREAS Function in Excel: How Many Blocks in a Reference
AREAS counts separate ranges in a reference — used with INDEX’s area_num argument to switch between tables.
Read article →GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA Function in Excel: Reliable Numbers From a Pivot Table
GETPIVOTDATA pulls a value from a pivot by field names, not by cell position — so your report keeps working when the pivot grows…
Read article →ISERR Function in Excel: Any Error Except #N/A
ISERR Function in Excel: Any Error Except #N/A
ISERR is TRUE for every error except #N/A. That lets you treat “not found” as normal while still catching real breakages like #DIV/0! or…
Read article →