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 coefficient of sales prediction based …
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 coefficient of sales prediction based …
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 not, others VALUE() worked, but …
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 with technology (since 1997) I …
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 level of expertise in each
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 single row (all columns for …
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 We can use the new …