4 ms·

heh, even though these are not completely analogous, I am reminded of old discussions when I would say 'I implemented this cool thing in C', and my roomie would

• ewjordan 17y ago
  This brings up a good point, though: there's a reason people that have struggled with the lack of built in functionality in languages like C tend to be better programmers, even if they make a switch to languages with more featureful standard libs. The act of hacking your way through even the smallest tasks teaches you a lot. And there are plenty of times in Excel where you'll need to hack your way through - it's got a lot of functionality, but once you move past what it's specifically designed to do, you'll start to get annoyed. That's when you start seeing INDIRECT and VLOOKUP all over the place, and you start to curse the developers that designed the whole damn system. More than a few times I've started some analysis in Excel, but decided in the end that I'd just rather fiddle with primitive arrays in a sane programming language because of the hoops you need to jump through in Excel. Perhaps if the scripting language was anything but VBA, if it was less tedious to add built in functions that you can use from the spreadsheet, or if the syntax for working with the spreadsheet from within VBA wasn't so heavy, it would be more tolerable, but you can't win them all...