Using INDEX to calculate a moving average dynamically
I have blogged before about how much I love INDEX (INDEX what’s the Big Deal ). It’s powerful, nimble (non volatile so easy on performance load) and just makes so much sense to me given we are working with a grid and INDEX essentially returns the contents from the co-ordinates of the grid reference entered. …
Using INDEX to calculate a moving average dynamically Read More »