Re:Google Sheets Query Function (2016)
by airstrike on Tuesday November 06, 2018 @10:16PM
(#18396872)
Why MS hasn't implemented a similar UDF in Excel is truly beyond me. No, Power BI isn't the same thing.
[ Parent
| on HN ]
Re:Google Sheets Query Function (2016)
by lostsock on Wednesday November 07, 2018 @12:58AM
(#18397372)
That looks really great, thanks for sharing!
Re:Google Sheets Query Function (2016)
by krembo on Wednesday November 07, 2018 @03:09AM
(#18397725)
While it's a cool project it cannot be compared to Sheets Query as long as Excel doesn't implement array expanding formulas (out-puting an array from a single cell formula).
PowerQuery is a very powerful tool for ETL is also not comparable as it's not natively integrated into Excel and still acts as an external component. [ex-Excel FTE here)
Re:Google Sheets Query Function (2016)
by chrispsn on Wednesday November 07, 2018 @03:24AM
(#18397785)
You're going to love this: https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of...
But you'll probably also love Mesh Spreadsheets: http://chrispsn.com/mesh-preview.html http://mesh-spreadsheet.com/
Re:Google Sheets Query Function (2016)
by airstrike on Wednesday November 07, 2018 @11:04AM
(#18399992)
Fuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuuck! I am in awe. Thank God. I can barely contain my enthusiasm.
I literally wrote a "SUPERLOOKUP" formula in VBA that would apply SORT and UNIQUE but making the range dynamic would require an XLL which is a beast I never had time to tame as a hobbyist... this is a dream come true. My eyes are literally watery. Wow.
Re:Google Sheets Query Function (2016)
by krembo on Wednesday November 07, 2018 @04:18AM
(#18398001)
Nice! I saw the initial versions of it, it took years to finish dev.
Re:Google Sheets Query Function (2016)
by josephjrobison on Wednesday November 07, 2018 @10:33AM
(#18399757)
Agreed, I would say query is the strongest reason to use Sheets over Excel