Repeated Offset
I needed to have an offset of columns to be repeated every 12 months. This is part of a project, we needed to calculate the...
VALUE() of LEFT()
I have been in a lot of situation needing to convert a number came out from a string into actual numbers. Sometimes N() worked, sometimes...
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...
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...
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...
New function IFERROR, finally
We have already gotten used to use VLOOKUP, MATCH and other functions that generates errors inside an IF But, we do not need that anymore...