Author: ANmar

Text-to-Columns, dynamically using formulas

ANmar April 3, 2018

Convert cell into textbox

ANmar March 28, 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

Excel ad from early 90s

ANmar March 14, 2018

Limited Ceiling

ANmar March 13, 2018

Count cells with condition – multiple conditions

ANmar February 16, 2018

Show developer tab

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