This was a challenge from a work colleague. I love this array solution!
Do you have another solution? Note that although the array is a bit heavy there are no slow volatile functions used (i.e. indirect). My blog post: https://www.myspreadsheetlab.com/larg...
https://www.myspreadsheetlab.com/extr...