4 ms·

https://www.querystorm.com https://www.querystorm.com

• lostsock 8y ago
  That looks really great, thanks for sharing!
  • krembo 8y ago
    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)
    • chrispsn 8y ago
      You're going to love this: https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of-Dynamic-Arrays-in-Excel/ba-p/252944 https://techcommunity.microsoft.com/t5/Excel-Blog/Preview-of... But you'll probably also love Mesh Spreadsheets: http://chrispsn.com/mesh-preview.html http://chrispsn.com/mesh-preview.html http://mesh-spreadsheet.com/ http://mesh-spreadsheet.com/
      • krembo 8y ago
        Nice! I saw the initial versions of it, it took years to finish dev.
      • airstrike 8y ago
        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.