## 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 …

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