ISNUMBER Function in Excel: Is It a Real Number?
ISNUMBER returns TRUE for numbers (and dates). Combined with SEARCH or MATCH, it turns “found / not found” into TRUE/FALSE.
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 →TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN Function in Excel: Join Text With a Separator, Skipping Blanks
TEXTJOIN joins a range of text with a delimiter and can ignore empty cells.
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 →WEBSERVICE Function in Excel: Read Data From a URL
WEBSERVICE Function in Excel: Read Data From a URL
WEBSERVICE downloads text from a web address (Windows desktop only). Combined with FILTERXML or TEXTAFTER it can read simple APIs.
Read article →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 →FILTER Function in Excel: Return Every Row That Matches
FILTER Function in Excel: Return Every Row That Matches
FILTER returns all rows (or columns) that meet a condition, and the result updates live as data changes.
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
CHOOSE returns the n-th item from a list of values you type in the formula.
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 →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 →ROWS Function in Excel: How Many Rows in a Range
ROWS Function in Excel: How Many Rows in a Range
ROWS counts the rows in a range or array — the classic helper for top-N lists that fill down.
Read article →