3 ms·
I hope so too. I've used QueryStorm for a year or so. I try to avoid Excel as much as possible, but when I have to use it, I can spend 4 hour learning the Excel
by xeonoex 9y ago
I hope so too. I've used QueryStorm for a year or so. I try to avoid Excel as much as possible, but when I have to use it, I can spend 4 hour learning the Excel/VBA way to do something, or 1 minute and write it in SQL. It doesn't make sense how this isn't in Excel already.
Seriously. Try to do a join and some simple data manipulation/aggregation in Excel without this. Or try to emulate SQL minus/except. You'll Google for simple answers using the UI, and those probably don't even solve your exact problem, then dig until you find some that seem correct, try to implement them, and then realizes it doesn't work for some unknown reason. Then either give in and write VBA to do it (which also sucks), or pull it out of Excel and put in something that uses a good language.
- anakic 9y agoThanks for writing this!