SimpleANBox
This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time...
Looplist – Repeating months using formulas
Using formulas to repeat list, I call it LoopList Used to list Months for several years, in away that with 1 formula, it will loop...
Scorring, saving multiple outputs in 1 number
I have seen this practice before several locations Returning multiple outputs in 1 single number. for example...
Compare2, a tool to compare two sheets using formulas
Tool will compare between two sheets using formula/functions method. Once you type in full folder locations (for both files), file names and sheets names in...
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...
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...
Limited Ceiling
The function CEILING (CEILING.Math as of Excel 2016) is a very good powerful function. It allows you to round number to any value up Unlike...