Is there any resource out there that explains how references and arrays work in excel for more technical people, or even specifically programmers?
All I've been able to on the internet is articles with generic examples, suitable so grandma accountant can take a look at them and press the right 3 buttons and be done with it.
No one actually tries to explain how any of it actually works, they just tell you how to use it!
Bookmarks