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 …
This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.
This is the spreadsheet to prove this constant. When all roads lead to Kaprekar Just enter any 4 digits number in D3 and watch roads walk you 6174
An old lesson to one of my early classes to show how can we cut a string having list of items into its parts. (At least 1st three parts) using …
Looks like there is a change coming. Excel started adding the symbol @ to some formulas, not sure why only those, but we are waiting to start using this new …
A technic I loved using, return list of items (up to 12 items now) in ONE number. Let us say you have list of 12 items, and you want a …