Back in March I did a post on three marketing uses for the OFFSET function. But, truth be told, I avoid the OFFSET function like the plague. The reason is that it’s very unstable and can bring large Excel files to their knees.
Why? Every time you modify the file the OFFSET function takes that as a cue to go ahead and run again.
It’s not alone. There are a few more functions that are volatile in this way, namely:
So what I decided to do was take all of the marketing uses I demonstrated in that video and show the INDEX alternative.
If you’d like to see how these look out in the wild, you can download the Excel file I used.
To learn about Excel functions — and more — check out out my Annielytics Dashboard Course offerings.