Category: Standard functions

Standard functions that comes with Excel, plain single functions

Skills Grid

ANmar October 26, 2018

Sheet() and Sheets()

ANmar August 22, 2018

Worksheet name, dynamically using formula

ANmar April 3, 2018

Text-to-Columns, dynamically using formulas

ANmar April 3, 2018

FORMULATEXT to show formulas

ANmar March 27, 2018

IFS (and IFNA) to avoid nested IFs

ANmar March 25, 2018

Highlight dates dynamically

ANmar March 14, 2018

Limited Ceiling

ANmar March 13, 2018

Count cells with condition – multiple conditions

ANmar February 16, 2018

Get monthly total from table with dates

ANmar December 26, 2017

IF with AND and IF with OR

ANmar December 25, 2017