Skills Grid
A small Excel file to show how we can create a chart-like Excel sheet Used in my Resume to show different skill sets and the...
Sheet() and Sheets()
Getting total number of sheets (Sheets), or ID of this sheet (Sheet). The two new formulas Sheet() and Sheets() can do well, yes not perfect,...
Worksheet name, dynamically using formula
Get the name of the active worksheet in active workbook, using formulas only This function needs to have workbook saved Then, you just paste below...
Text-to-Columns, dynamically using formulas
I often use the technique of concatenating columns into 1 cell with separators. Something like the CSV, 1 line that has all values for a...
Convert cell into textbox
Often times, I found myself the need to design a sheet where I want users to input something, and I need them to focus on...
FORMULATEXT to show formulas
Back in the day, we used to need to write a full macro (also called User-Defined-Function) to allow users to show the formula from a...
IFS (and IFNA) to avoid nested IFs
I tend to see more and more the usage of nested IF functions recently Now, do not get me wrong, IF is great, but come...